Re: plpgsql returning resultset

On 02/09/2008 11:12, tfinneid(at)student(dot)matnat(dot)uio(dot)no wrote:

> create function test2() returns setof record as
> $$
> declare
> val_list record;
> begin
> select * into val_list from tableA;
> return next val_list;
> return:
> end
> $$ .....

Hi there,

You need to do it like this:

with val_list in
select * from tableA do
loop
return next val_list;
end loop;
return;

There's an example here:

http://www.postgresql.org/docs/8.3/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------