Re: [GENERAL] can a function have a setof (returned from another function) as input

2011-03-28 Thread Merlin Moncure
On Mon, Mar 28, 2011 at 1:55 PM, Terry Kop wrote: > I'm trying to create a function that will take setof results from various > other functions (they all produce the same output format). Is this possible? > if so how do call it. > > ex. > CREATE TYPE emp_t AS ( > ID int, > name   varch

Re: [GENERAL] can a function have a setof (returned from another function) as input

2011-03-28 Thread Pavel Stehule
Hello 2011/3/28 Terry Kop : > I'm trying to create a function that will take setof results from various > other functions (they all produce the same output format). Is this possible? > if so how do call it. No, this isn't possible. Regards Pavel Stehule > > ex. > CREATE TYPE emp_t AS ( > ID  

[GENERAL] can a function have a setof (returned from another function) as input

2011-03-28 Thread Terry Kop
I'm trying to create a function that will take setof results from various other functions (they all produce the same output format). Is this possible? if so how do call it. ex. CREATE TYPE emp_t AS ( ID int, name varchar(10), age int, salary real, start_date date, city