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,,