Simulating CURSORS?? - Mailing list pgsql-sql

From p.lam@altavista.net
Subject Simulating CURSORS??
Date
Msg-id 000601195935K8.25440@weba1.iname.net
Whole thread Raw
List pgsql-sql
I read from messages like http://www.postgresql.org/mhonarc/pgsql-sql/1999-11/msg00076.html that CURSORS could not be
usedwith pg/plsql, and indeed attempting to do so result in the same kind of error highlighted in that message.
 
Are there any other ways I could with pgplsql simuate the use of Cursors and write functions that could fetch and
processrecords row by row retrieved from a SELECT statement (and then put the processed data back to another table)?
 


----------------------------------------------------------------
Get your free email from AltaVista at http://altavista.iname.com


pgsql-sql by date:

Previous
From: bill@wadley.org
Date:
Subject: I'm missing outer joins
Next
From: Tom Lane
Date:
Subject: Re: short query becomes long