[Mapserver-users] Classes based on Postgis && function

[Jan Hartmann]

We both missed it. It's "using UNIQUE <var> using SRID=<srid>"

with *one* =

Also, in older versions, capitals have to be *exactly* as above.

So it wasn't a bug. Thanks to Dave Blasby for pointing it out.

Jan

Benjamin Wragg wrote:
> It didn't work for me. Could you please post your data statement so I
> can check I'm not missing something.
> 
> Cheers,
> 
> Benjamin
> 
> -----Original Message-----
> From: mapserver-users-admin at lists.gis.umn.edu
> [mailto:mapserver-users-admin at lists.gis.umn.edu] On Behalf Of Jan
> Hartmann
> Sent: Saturday, 22 February 2003 6:47 AM
> To: mapserver-users at lists.gis.umn.edu
> Subject: Re: [Mapserver-users] Classes based on Postgis && function
> 
> 
> Later ...
> 
> I put parentheses around the CASE statement (before CASE and after END) 
> and now it works! Could you try this too?
> 
> Jan
> 
> Jan Hartmann wrote:
> 
>>Hmm, this looks like a bug: the two SQL statements are exactly the 
>>same,
>>except for the USING statement. Also, the SQL in the error message is 
>>different from the original one (and definitely erroneous). Looks like
> 
> 
>>the parser in mappostgis.c chokes on the combination of CASE WHEN and 
>>USING. In my own setup I have always run CASE statements without
> 
> USING. 
> 
>>I added USING now, and got the same error message. I guess the PostGIS
> 
> 
>>folks should have a look at this.
>>
> 
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> 
> 
Jan Hartmann
Department of Geography
University of Amsterdam