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.

Oh, NVL and isnull are not standard?  Then let's just use coalesce.  I
will remove them from the TODO list.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026