Pass a list of records from a function

[Stedo]

hi,

Is it possible to return a list of records from a Stored Procedure?

For example,

SELECT * FROM my_table

If so what type do I use for returning these?

Thanks
Steve

 

[ceco]

yes you can
see here

http://www.postgresql.org/docs/8.1/interactive/xfunc-sql.html

http://www.postgresql.org/docs/8.1/static/plpgsql-cursors.html

http://www.postgresql.org/docs/8.1/interactive/plperl-database.html