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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: hlefebvre(at)easynet(dot)fr (H(dot)Lefebvre)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: AW: [HACKERS] isnull() or is it?t
Date: 1998-12-09 15:10:07
Message-ID: 199812091510.KAA10144@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Oleg Broytmann 1998-12-09 15:16:01 Re: [HACKERS] Date/time on glibc2 linux
Previous Message Bruce Momjian 1998-12-09 15:08:12 Re: AW: AW: [HACKERS] isnull() or is it?t