Horton

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

Bruce Momjian <maillist@candle.pha.pa.us>

View thread
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: hlefebvre@easynet.fr (H.Lefebvre)
Cc: pgsql-hackers@postgreSQL.org
Date: 1998-12-09T15:10:07Z
Lists: 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, Pennsylvania 19026