On Thu, Sep 07, 2006 at 12:58:17PM +0200, Stefan Schwarzer wrote:
> Unfortunately the mapserver can't deal with NULL values. So, I can't
> build a class saying
> if values = NULL do something
> but instead it only works with "fake" NULL values as -9999
> if values = -9999 do something

That's because nothing is equal to NULL. You say "values IS NULL".

And COALESCE(a,b) is pretty mutch: IF a IS NULL THEN b ELSE A

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFE//0tIB7bNG8LQkwRAikRAJ9QqOg12zn0wJN7kvTvdP1+Ov+yFACd G1eQ
uajnbsDrQeXZv0zNHZdbVgg=
=/5e0
-----END PGP SIGNATURE-----