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: | Raw Message | Whole Thread | 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? |