|PostgreSQL Reference Manual - Volume 2 - Programming Guide|
by The PostgreSQL Global Development Group
Paperback (6"x9"), 408 pages
RRP £19.95 ($34.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
9.8.3 Using Cursors
Once a cursor has been opened, it can be manipulated with the statements described here.
These manipulations need not occur in the same function that
opened the cursor to begin with. You can return a
value out of a function and let the caller operate on the cursor.
refcursor value is simply the string name
of a so-called portal containing the active query for the cursor. This name
can be passed around, assigned to other
and so on, without disturbing the portal.)
All portals are implicitly closed at transaction end. Therefore
refcursor value is usable to reference an open cursor
only until the end of the transaction.
|ISBN 0954612035||PostgreSQL Reference Manual - Volume 2 - Programming Guide||See the print edition|