COALESCE() bug?

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

Предыдущее
От: Matthew Hagerty
Дата:
Сообщение: Re: [SQL] Join with blank records.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] COALESCE() bug?