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

[Jan Hartmann]

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.
>