Function taking compound type defined on a view with ORDER BY

From: Richard Huxton <dev(at)archonet(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Function taking compound type defined on a view with ORDER BY
Date: 2005-10-19 16:02:46
Message-ID: 43566E26.7030302@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Earlier today Hakan Kocaman (Hakan(dot)Kocaman(at)digame(dot)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

Attachment Content-Type Size
view_rectype_fn.sql text/x-sql 737 bytes

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-10-19 16:03:05 Re: union bug
Previous Message Ivan 2005-10-19 14:12:03 union bug