Re: Improving ALTER TYPE support - Mailing list pgsql-hackers

From John Jawed
Subject Re: Improving ALTER TYPE support
Date
Msg-id a9eb35850605241204w4d6be2a0ra485cb584bfd992d@mail.gmail.com
Whole thread Raw
In response to Re: Improving ALTER TYPE support  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Improving ALTER TYPE support
List pgsql-hackers
I guess I don't understand what one has to do with the other (SRF's returning records and OUT parameters). I always thought they were exclusive, could you elaborate?

On 5/24/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Josh Berkus <josh@agliodbs.com> writes:
>> I've been working on a function which returns a setof a composite type.
>> Everytime I've changed the structure of the returning setof, I've had to
>> change the type accordingly, which current means doing a drop type ...
>> cascade down to the function. We should allow one of the following:

> Why not go all the way and work out a way to define an SRF return type as a
> part of the function?  e.g.

Um, isn't that exactly what the OUT parameter support already gives you,
ie, an anonymous record type?

                        regards, tom lane

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Further reduction of bufmgr lock contention
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Why is CVS server so slow?