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

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: "H(dot)Lefebvre" <hlefebvre(at)easynet(dot)fr>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: AW: [HACKERS] isnull() or is it?t
Date: 1998-12-09 15:21:53
Message-ID: 366E9591.6EF51E57@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

- Tom

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas G. Lockhart 1998-12-09 15:26:52 Re: [HACKERS] problem compiling with egcs 1.1.1
Previous Message Oleg Broytmann 1998-12-09 15:16:01 Re: [HACKERS] Date/time on glibc2 linux