Ticket #2888 (closed defect: worksforme)
postgis DATA statements do not allow quoted strings embedded in them
|Reported by:||woodbri||Owned by:||pramsey|
The following issue has been raise multiple times in recent weeks. This seems like it is a pretty major limitation.
Travis Kirstine <traviskirstine@…> 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"