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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Andreas(dot)Zeugswetter(at)telecom(dot)at (Zeugswetter Andreas IZ5)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: AW: AW: [HACKERS] isnull() or is it?t
Date: 1998-12-09 15:08:12
Message-ID: 199812091508.KAA10104@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.
>
> Yes, the difference is only the name of the function.

isnull() is used by Ingres.

--
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 Bruce Momjian 1998-12-09 15:10:07 Re: AW: [HACKERS] isnull() or is it?t
Previous Message Bruce Momjian 1998-12-09 15:07:23 Re: AW: [HACKERS] isnull() or is it?t