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

From Thomas G. Lockhart
Subject Re: [HACKERS] isnull() or is it?t
Date
Msg-id 366E0443.6E09E2CE@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] isnull() or is it?t  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] isnull() or is it?t  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> isnull() is on our TODO list.

If the one-line description in the TODO list is accurate and complete,
istm that the SQL92-standard function COALESCE() which I put into the
current development tree as part of the CASE feature does that and more.

Neither function would allow an inner join to magically become an outer
join. Speaking of which, remember that you're planning on helping with
outer joins for the next release, right? Or at least you haven't turned
me down yet... :)
                     - Tom


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] isnull() or is it?t
Next
From: "Thomas G. Lockhart"
Date:
Subject: OID min/max functions