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

From Tom Lane
Subject Re: Improving ALTER TYPE support
Date
Msg-id 1280.1148501273@sss.pgh.pa.us
Whole thread Raw
In response to Re: Improving ALTER TYPE support  ("John Jawed" <johnjawed@gmail.com>)
Responses Re: Improving ALTER TYPE support
Re: Improving ALTER TYPE support
List pgsql-hackers
"John Jawed" <johnjawed@gmail.com> writes:
> 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?

(BTW, please don't post uselessly HTML-ified mail.)

If you write something like
create function foo (in p1 int, out r1 int, out r2 text)returns setof record

then you've effectively got a function returning an anonymous composite
type (here, with one int and one text column).  I don't see a case for
inventing a separate facility that will pretty much just duplicate this
functionality.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: file-locking and postmaster.pid
Next
From: Simon Riggs
Date:
Subject: Re: error-free disabling of individual child partition