Cristiano, Lo que dice la documentación ad literam es: If this is a PostGIS layer, the parameter should be in the form of “<columnname> from <tablename>”, where “columnname” is the name of the column containing the geometry objects and “tablename” is the name of the table from which the geometry data will be read.
Por lo que creo que no es válido hacer uso de caracteres de escape. Yo en lo personal, he tenido problemas con el escape de comillas dobles y simples dentro de las expresiones en las etiquetas EXPRESSION, supongo que tal vez esto del escape no funcione de manera estática (desde el archivo MAP) sino de manera dinámica (Haciendo uso de Mapscript). Saludos desde México IC Carlos Ruiz ________________________________ From: Cristiano Sumariva <sumar...@gmail.com> To: mapserver-users@lists.osgeo.org Sent: Tue, June 8, 2010 2:24:35 PM Subject: [mapserver-users] Escape caracter on Mapfile People I got on this situation: mixing single quotes with double quotes. Mapserver say at following page : http://mapserver.org/mapfile/expressions.html that for expressions it allow escape. Do it allow escape on other mapfile attributes ? Current mapserver version is 5.4.1 I need the following string layer data attribute to create an query to perform a column concat since address is a compound information and has some null values. I know some will say fix your data. It is stopping at CATEG: Parsing error near (CATEG) data "the_geom from ( select oid, *, \"CATEG\"||( CASE WHEN \"PREP\" is null THEN ' '::text ELSE \"PREP\" END )||\"LOGR\" as full_address from street_main_dissolv_utm ) as street_main_address_with_length_over_ten_kilometer" Postgresql lexer rules are: Identifiers are quoted with double quotes. A column name is an identifier. And column name identifiers not quoted are lower cased. So need the double quotes around those upper case identifiers. Text strings are quoted in single quotes. || is string concat operator
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users