From: | Vince Vielhaber <vev(at)michvhf(dot)com> |
---|---|
To: | pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: AW: [HACKERS] isnull() or is it?t |
Date: | 1998-12-09 16:16:42 |
Message-ID: | Pine.HPP.3.94.981209111357.9766D-100000@cinnamon.michvhf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
==========================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 1998-12-09 16:19:46 | Re: [HACKERS] plTcl test failed |
Previous Message | Tom Lane | 1998-12-09 16:15:15 | Re: [HACKERS] problem compiling with egcs 1.1.1 |