Re: [HACKERS] Associative Operators? (Was: Re: [NOVICE] Out of frying pan, into fire) - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] Associative Operators? (Was: Re: [NOVICE] Out of frying pan, into fire)
Date
Msg-id 36FBA80F.EDF7155B@alumni.caltech.edu
Whole thread Raw
In response to RE: [HACKERS] Associative Operators? (Was: Re: [NOVICE] Out of f rying pan, into fire)  (Michael Davis <michael.davis@prevuenet.com>)
List pgsql-hackers
> I have not been able to track down any information on coalesce nor get
> PostgreSQL execute it.  Where is this documented?

Hmm. I seem to not have put it into the docs yet. Look at any SQL book
written in the last few years for details on its usage, or ask here.

btw, COALESCE() is a special case of CASE, which is also implemented,
but which currently has problems with handling results from multiple
tables.
                    - Tom


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: New regress test (was Re: Timespan_div misbehaving?)
Next
From: Tom Lane
Date:
Subject: pg_parg system table is suffering from software rot