Re: Replace NULL values

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Replace NULL values
Дата
Msg-id 20060907110621.GH10093@svana.org
обсуждение исходный текст
Ответ на Re: Replace NULL values  (Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>)
Список 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.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Stefan Schwarzer
Дата:
Сообщение: Re: Replace NULL values
Следующее
От: Valentin Militaru
Дата:
Сообщение: Fwd: Help using user rights