Re: plpgsql returning resultset

From: tfinneid(at)student(dot)matnat(dot)uio(dot)no
To: rod(at)iol(dot)ie
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql returning resultset
Date: 2008-09-02 11:18:44
Message-ID: 47918.134.32.140.234.1220354324.squirrel@webmail.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Does that work in 8.2, cause i get the same error message as I described
above

regards

thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-09-02 11:19:34 MERGE: performance advices
Previous Message jose lawrence 2008-09-02 11:16:06 Conflict between MVCC and manual locking