Re: Replace NULL values - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Replace NULL values
Date
Msg-id 20060907110621.GH10093@svana.org
Whole thread Raw
In response to Re: Replace NULL values  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
List pgsql-general
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.

Attachment

pgsql-general by date:

Previous
From: Stefan Schwarzer
Date:
Subject: Re: Replace NULL values
Next
From: Valentin Militaru
Date:
Subject: Fwd: Help using user rights