Re: plpgsql - fetching from returned cursors - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql - fetching from returned cursors
Date
Msg-id 23400.1044587814@sss.pgh.pa.us
Whole thread Raw
In response to plpgsql - fetching from returned cursors  ("k|p" <m.e.meulemans@student.utwente.nl>)
List pgsql-general
"k|p" <m.e.meulemans@student.utwente.nl> writes:
> Is something like this possible?
> Because the way I wrote it now, nothing is FOUND from the FETCH and the loop is
> exited.

It works for me ... or at least it did after I changed "my_row" to type
RECORD, added a RETURN at the end, and made the RAISE be RAISE NOTICE
so I could actually see some output.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: How many joins is too many joins....
Next
From: "kanchana"
Date:
Subject: Re: start error - pgsql