Re: plpgsql - fetching from returned cursors

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "k|p" <m(dot)e(dot)meulemans(at)student(dot)utwente(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: plpgsql - fetching from returned cursors
Date: 2003-02-07 03:16:54
Message-ID: 23400.1044587814@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"k|p" <m(dot)e(dot)meulemans(at)student(dot)utwente(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-02-07 03:35:36 Re: "Cannot insert a duplicate key..." -- but where?
Previous Message Tom Lane 2003-02-07 03:01:52 Re: How many joins is too many joins....