On Sat, Feb 7, 2009 at 12:57, Lars Lingner <[email protected]> wrote: > Rahkonen Jukka schrieb: >> Lars Lingner wrote: >> >> >> >>> I see that you also had to rename the column "natural". As this is an >>> reserved name by postgres, is there an way to use such a name in an >>> mapserver expression? >>> Although renaming the column did work for me I just want to know how to >>> quote correctly. I don't think you can if you need to do a string comparison in your sql where clause, as there's no way in mapserver to escape the ' or " characters
> > DATA "way from (select way,osm_id ,name from planet_osm_polygon where > 'natural'='water' ) as foo using unique osm_id using srid=900913" > > was not working... but I just tried it again, just to make sure I don't > say anything wrong... and its working. *doh* it's a valid sql clause, but useless for mapserver as it won't return any data (as the string 'water' and 'natural' are never equal) regards, thomas _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
