> > 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
