Received: from rmx602-mta.mail.com (rmx602-mta.mail.com [165.251.48.51]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA67269 for ; Thu, 1 Jun 2000 19:59:36 -0400 (EDT) (envelope-from p.lam@altavista.net) From: p.lam@altavista.net Received: from weba1.iname.net (weba1.iname.net [165.251.4.11]) by rmx602-mta.mail.com (8.9.3/8.9.3) with ESMTP id TAA01106 for ; Thu, 1 Jun 2000 19:59:36 -0400 (EDT) Received: (from root@localhost) by weba1.iname.net (8.9.1a/8.9.2.Alpha2) id TAA06609; Thu, 1 Jun 2000 19:59:35 -0400 (EDT) MIME-Version: 1.0 Message-Id: <000601195935K8.25440@weba1.iname.net> Date: Thu, 1 Jun 2000 19:59:35 -0400 (EDT) Content-Type: Text/Plain Content-Transfer-Encoding: 7bit To: pgsql-sql@postgresql.org Subject: Simulating CURSORS?? X-Archive-Number: 200006/11 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