Re: AW: [HACKERS] isnull() or is it?t

Поиск
Список
Период
Сортировка
От Thomas G. Lockhart
Тема Re: AW: [HACKERS] isnull() or is it?t
Дата
Msg-id 366E9591.6EF51E57@alumni.caltech.edu
обсуждение исходный текст
Ответ на AW: [HACKERS] isnull() or is it?t  (Zeugswetter Andreas IZ5 <Andreas.Zeugswetter@telecom.at>)
Ответы Re: AW: [HACKERS] isnull() or is it?t  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
> With SyBase, IsNull(X,Y) returns X if X is not null, and Y
> if X is null.

Which is identical in behavior to the SQL92-defined function
COALESCE(X,Y) (IsNull() is not in the standard). This is now in the
Postgres development tree, to be available in the next release. Should
we also have the less capable IsNull() available too? COALESCE() has the
nice feature that it takes an unlimited number of arguments, returning
the first non-null result.
                  - Tom


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

Предыдущее
От: Oleg Broytmann
Дата:
Сообщение: Re: [HACKERS] Date/time on glibc2 linux
Следующее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [HACKERS] problem compiling with egcs 1.1.1