| From: | Jens Glaser <jens(at)helena(dot)jens(dot)de> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | COALESCE() bug? |
| Date: | 1999-07-29 01:29:57 |
| Message-ID: | Pine.LNX.4.05.9907290125320.13349-100000@helena.jens.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
the following SQL statement gives an error:
ERROR: fix_indxqual_references: Cannot handle node type 723
if I leave out the COALESCE() statements, everything is ok..
(Postgresql 6.5.1-2, Debian Package)
Regards,
SQL query:
SELECT
o.f_number as ordNo, o.shortDescription as ordDesc,
o.f_date as ordDate, o.autoEntry as ordAEnt,
o.objectid as objectid, o.invoiceAddrKindID as invAddr,
o.delNoteAddrKindID as delAddr, o.currency as currency,
pt.name as cond, o.f_comment as comment
FROM
Orders o, PaymentTerms pt
WHERE
(coalesce(o.paymentTermsOId,-1)=pt.objectid) and
(o.customerOID = 300)
UNION SELECT
o.f_number as ordNo, o.shortDescription as ordDesc,
o.f_date as ordDate, o.autoEntry as ordAEnt, o.objectid as objectid,
o.invoiceAddrKindID as invAddr, o.delNoteAddrKindID as delAddr,
o.currency as currency, pt.name as cond, o.f_comment as comment
FROM
Orders o, PaymentTerms pt
WHERE
(coalesce(o.paymentTermsOId,-1)=pt.objectid) and
(o.customerOID = 300)
ORDER by ordDate, ordNo
--
Jens Glaser Am Holderstrauch 13, 36041 Fulda, 0661/9429507 jens(at)jens(dot)de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Inform() | 1999-07-29 02:35:58 | Form making with psql and php.cgi |
| Previous Message | Bruce Momjian | 1999-07-29 00:28:18 | Re: [SQL] COALESCE() bug? |