Re: AW: [HACKERS] isnull() or is it?t - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: AW: [HACKERS] isnull() or is it?t
Date
Msg-id 199812091510.KAA10144@candle.pha.pa.us
Whole thread Raw
In response to Re: AW: [HACKERS] isnull() or is it?t  ("H.Lefebvre" <hlefebvre@easynet.fr>)
List pgsql-hackers
> Zeugswetter Andreas IZ5 wrote:
> > 
> >         > isnull() is on our TODO list.
> > 
> >         It should be called NVL() from "Null VaLue" like in Oracle and
> > Informix.
> >         isnull() would suggest a boolean return value to me.
> > 
> 
> 
> With SyBase, IsNull(X,Y) returns X if X is not null, and Y
> if X is null.

We should support both isnull() and nvl().  On the TODO list now.

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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: AW: [HACKERS] isnull() or is it?t
Next
From: Bruce Momjian
Date:
Subject: Re: AW: AW: [HACKERS] isnull() or is it?t