| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Stefan Schwarzer <stefan(dot)schwarzer(at)grid(dot)unep(dot)ch> |
| Cc: | Sim Zacks <sim(at)compulab(dot)co(dot)il>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Replace NULL values |
| Date: | 2006-09-07 11:06:21 |
| Message-ID: | 20060907110621.GH10093@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Valentin Militaru | 2006-09-07 11:12:57 | Fwd: Help using user rights |
| Previous Message | Stefan Schwarzer | 2006-09-07 10:58:17 | Re: Replace NULL values |