From: | p(dot)lam(at)altavista(dot)net |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Simulating CURSORS?? |
Date: | 2000-06-01 23:59:35 |
Message-ID: | 000601195935K8.25440@weba1.iname.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I read from messages like http://www.postgresql.org/mhonarc/pgsql-sql/1999-11/msg00076.html that CURSORS could not be used with 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 process records 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-02 02:31:59 | Re: short query becomes long |
Previous Message | bill | 2000-06-01 19:53:29 | I'm missing outer joins |