Re: Return type for procedure

["ben sewell" <mosherben(at)gmail(dot)com>]

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