On 02/09/2008 11:12, tfinneid@student.matnat.uio.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@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------