postgis DATA statements do not allow quoted strings embedded in them

[woodbri]

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"

[pramsey]

Not a problem in 5.4+

[pramsey]

Actually, this works for me in 5.2 also. Are you sure you're reporting the right symptom?

    DATA "the_geom from (select * from states where state_name = 'Nebraska') as 
subsql using srid=4326 using unique gid"

[woodbri]

I'm using 5.2.2 and just happen to be working with postgis queries that have single quoted strings in them and it works for me. This was a real problem at the time I posted it because I'm pretty sure I tested it to verify the problem, so I'm guessing that the mapfile parser was tweaked to fix this without closing the bug.