PL/pgSQL & Cursors - Mailing list pgsql-sql

From Dwelle, Timothy
Subject PL/pgSQL & Cursors
Date
Msg-id 0C95935DA0D5D3118E9800A0C9824CD02B8A19@mail.xperts.com
Whole thread Raw
Responses Re: PL/pgSQL & Cursors  (wieck@debis.com (Jan Wieck))
List pgsql-sql
I have been playing around with the PL/pgSQL stuff, and I have
been having trouble getting cursors to work inside my PL/pgSQL
functions.  Reading through the documentation, I see that:

(1) cursors must occur inside a transaction, and
(2) PL/pgSQL functions cannot start or end a transaction

Does this mean there is no way to use cursors inside a
PL/pgSQL function?

Any help would be appreciated.


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Maxima per row
Next
From: Andy Lewis
Date:
Subject: Cursors and PHP