Re: plpgsql returning resultset

On 02/09/2008 21:55, Thomas Finneid wrote:
>     with val_list in
>       select * from tableA
>     do
>     loop
>       return next val_list;
>     end loop;

Oops - my mistake - it should indeed be FOR, not WITH, hence your error
message.

One other thing in the above - you don't need the DO, it's just
FOR...LOOP...END LOOP.

Ray.



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