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
