COALESCE() bug?

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

Browse pgsql-sql by date

  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?