id summary reporter owner description type status priority milestone component version severity resolution keywords cc 2888 postgis DATA statements do not allow quoted strings embedded in them woodbri pramsey "The following issue has been raise multiple times in recent weeks. This seems like it is a pretty major limitation. >>> Travis Kirstine 02/12/09 1:45 PM >>> 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"" }}} " defect closed normal PostGIS Interface 5.2 major worksforme