Re: AW: [HACKERS] isnull() or is it?t - Mailing list 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