I don't see why you're a problem with that query string. From my experience, there's a limitation when you need to mix single and double quotes inside the sql expression.
eg: DATA "way from (select way,osm_id ,leisure , landuse, name from osm_polygon where leisure='park' or leisure='golf_course' or landuse='recreation_ground' or landuse='cemetery') as foo using unique osm_id using srid=900913" works fine. Travis, could you post your exact data statement, so we can check if your problem isn't elsewhere? regards, thomas On Thu, Feb 12, 2009 at 20:45, Travis Kirstine <[email protected]> wrote: > The following line does not work and I think it has something to do > with the single quotes. When I use double quotes Postgres thinks I'm > referring to a column name. Is there a way to escape the single > quotes? > DATA "geom from (select id as oid, geom from some_table where > some_field = 'some_string') as myquery using SRID=-1" > > The following line works because I'm doing a numeric comparison. > DATA "geom from (select id as oid, geom from some_table where > some_field_number = 99) as myquery using SRID=-1" > > > -- > Travis K. > > Toronto, Canada > ------------------------------------------------------------ > "She knows there's no success like failure > And that failure's no success at all." > -Bob Dylan- > ------------------------------------------------------------ > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
