Re: plpgsql returning resultset

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
------------------------------------------------------------------