COALESCE() bug?
От | Jens Glaser |
---|---|
Тема | COALESCE() bug? |
Дата | |
Msg-id | Pine.LNX.4.05.9907290125320.13349-100000@helena.jens.de обсуждение исходный текст |
Ответы |
Re: [SQL] COALESCE() bug?
|
Список | 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_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
В списке pgsql-sql по дате отправления: