Re: Improving ALTER TYPE support

Поиск
Список
Период
Сортировка
От John Jawed
Тема Re: Improving ALTER TYPE support
Дата
Msg-id a9eb35850605241204w4d6be2a0ra485cb584bfd992d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Improving ALTER TYPE support  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Improving ALTER TYPE support
Список 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 по дате отправления:

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Further reduction of bufmgr lock contention
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: Why is CVS server so slow?