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_commentas 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.objectidas objectid, o.invoiceAddrKindID as invAddr, o.delNoteAddrKindID as delAddr, o.currency as currency,
pt.nameas 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@jens.de