[mapserver-users] RE: 5.4 beta 3 - GetFeatureInfo /FILTER problems

Gregor at HostGIS gregor at hostgis.com
Thu Mar 12 17:00:34 EDT 2009


Jennifer Shanks wrote:
> FILTER "(access_cod = 'Restricted Access' or access_cod = 'Open Access')"

I suggested the parens as disambiguation, when I saw this in 
PostgreSQL's query log.

WHERE code = 'Restricted' or code = 'Open' and gid = 12345

As such, her own FILTER clause seems just fine but when combined with 
MapServer's behind-the-work an ambiguous clause was generated. Would it 
be appropriate to open a ticket on this, to have the PostGIS driver 
automatically place the statement in parens in order to prevent such 
"MapServer-induced ambiguity" ?

-- 
HostGIS, Open Source solutions for the global GIS community
Greg Allensworth - SysAdmin, Programmer, GIS Person, Security
Network+   Server+   A+   Security+


More information about the mapserver-users mailing list