Re: Return type for procedure

Hi Jaime,
thanks for your reply.

Could anyone check if this is correct for what I'm trying to do

CREATE FUNCTION test(id integer,name varchar,date_start date date_end date)
RETURNS record as $$
$$ language 'your-language';

if id="1" then
select * from tblemployee;
elseif id="2" then
select client_name,address
from tblclients;
endif

and then execute the function as

select * from test() as (report1, report2)

would this work? This is just example code for select statements which are
far much longer

Cheers,
Ben

On 8/16/06, Jaime Casanova <systemguards(at)gmail(dot)com> wrote:
>
> >
> > What I was wondering was if it was possible for me to return different
> user
> > defined types. To try to illustrate what I mean, here's some example
> code
> > which I think is allowed:
> >
>
> yes.
>
> just create your functions as:
>
> CREATE FUNCTION test() RETURNS record as $$
> $$ language 'your-language';
>
> then execute the function as
>
> select * from test() as (field1 type1, field2 type2...);
>
> --
> regards,
> Jaime Casanova
>
> "Programming today is a race between software engineers striving to
> build bigger and better idiot-proof programs and the universe trying
> to produce bigger and better idiots.
> So far, the universe is winning."
> Richard Cook
>