Thread: multi results with functions

Hi

Im trying to make a stored procedure that returns * from at table, and
returns multible rows. Can you do that, and how?

basically I would like to do:

create or replace function test () returns record as 'select * from dummytable;
' language sql;

Thanks
- Kasper

hi,

kasper wrote, On 5/31/2004 00:02:
> Hi
> 
> Im trying to make a stored procedure that returns * from at table, and
> returns multible rows. Can you do that, and how?
> 
> basically I would like to do:
> 
> create or replace function test () returns record as '
>  select * from dummytable;
> ' language sql;

returns SETOF dummytable as ' ....

C.