View Single Post

   
  #4 (permalink)  
Old 04-12-2008, 02:35 AM
Tom Lane
 
Posts: n/a
Default Re: Improving ALTER TYPE support

"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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote