Re: Improving ALTER TYPE support

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, "John Jawed" <johnjawed(at)gmail(dot)com>
Subject: Re: Improving ALTER TYPE support
Date: 2006-05-24 13:52:50
Message-ID: 28527.1148478770@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2006-05-24 13:55:31 Re: Updatable views/with check option parsing
Previous Message Tom Lane 2006-05-24 13:40:27 Re: error-free disabling of individual child partition