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

On Wed, 9 Dec 1998, Bruce Momjian wrote:

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

Surprises me too. I was under the (incorrect) impression that isnull
was standard.

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev(at)michvhf(dot)com flame-mail: /dev/null
# include <std/disclaimers.h> TEAM-OS2
Online Searchable Campground Listings http://www.camping-usa.com
"There is no outfit less entitled to lecture me about bloat
than the federal government" -- Tony Snow
==========================================================================