Function taking compound type defined on a view with ORDER BY

Started by Richard Huxtonover 20 years ago2 messagesbugs

dev@archonet.com

over 20 years ago

Earlier today Hakan Kocaman (Hakan.Kocaman@digame.de) posted a query on
general "Issue with functions in Rule".

Turned out the problem is with a function that takes a compound type
based on a view with ORDER BY. If you add/remove ORDER BY to the view
definition in the attached it doesn't recognise the type (I think)

The error is different in 8.0.x and 8.1.x but occurs in both.

--
Richard Huxton
Archonet Ltd

Tom Lane

tgl@sss.pgh.pa.us

over 20 years ago

In reply to: Richard Huxton (#1)

Re: Function taking compound type defined on a view with ORDER BY

Richard Huxton <dev@archonet.com> writes:

The error is different in 8.0.x and 8.1.x but occurs in both.

Fixed in CVS tip --- will look at the 8.0 branch later.

regards, tom lane

Function taking compound type defined on a view with ORDER BY

Attachments: