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

[Benjamin Wragg]

Hi guys,

I just wanted to say a huge thankyou to all who helped me with my many
problems and questions regarding complex queries and layer definitions
of PostGIS data. Jan Hartmann and David Blasbly especially provided
first class help and support.

Thanks heaps,

Benjamin Wragg


-----Original Message-----
From: Jan Hartmann [mailto:jhart at frw.uva.nl] 
Sent: Sunday, 23 February 2003 12:14 AM
To: bwragg at tpg.com.au; mapserver-users at lists.gis.umn.edu
Subject: Re: [Mapserver-users] Classes based on Postgis && function


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