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

2005-10-19 Thread Tom Lane
Richard Huxton 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 ---(end of broadcast)--- TIP 6: explain analyze is your friend

[BUGS] Function taking compound type defined on a view with ORDER BY

2005-10-19 Thread Richard Huxton
Earlier today Hakan Kocaman ([EMAIL PROTECTED]) 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 t