| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | "George Henry C(dot) Daswani" <gdaswani(at)esri(dot)com>, pgsql-sql(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [SQL] Re: Problem with coalesce.. |
| Date: | 2000-11-02 08:09:10 |
| Message-ID: | 24580.973152550@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> There are still some contexts in which subqueries in expressions are
> wierd. The example below appears to work in current sources however.
>> SELECT COALESCE ((SELECT CURVALUE FROM TABLEKEYS WHERE TABLENAME = 'BUYER'),1)
>> returns a "UNKNOWN expression type 501"
AFAICT it works in 7.0.* as well. Are you sure this was 7.0.2, and
not 6.5.something?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-11-02 08:33:10 | Re: [NOVICE] Array Problem |
| Previous Message | jsahn | 2000-11-02 05:39:30 | set digest |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2000-11-02 16:37:32 | Re: Outer Joins |
| Previous Message | Gerhard Dieringer | 2000-11-02 07:55:53 | Antw: Outer Joins |