Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: view_rectype_fn.sql
Description: text/x-sql (737 bytes)

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-10-19 16:03:05
Subject: Re: union bug
Previous:From: IvanDate: 2005-10-19 14:12:03
Subject: union bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group