Received: from mail_ric.xperts.com (mail.xperts.com [206.154.243.11]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA65466 for ; Fri, 7 Apr 2000 10:48:20 -0400 (EDT) (envelope-from TDwelle@xperts.com) Received: by mail.xperts.com with Internet Mail Service (5.5.2650.21) id <2HJAQXC1>; Fri, 7 Apr 2000 10:47:05 -0400 Message-ID: <0C95935DA0D5D3118E9800A0C9824CD02B8A19@mail.xperts.com> From: "Dwelle, Timothy" To: "'pgsql-sql@postgresql.org'" Subject: PL/pgSQL & Cursors Date: Fri, 7 Apr 2000 10:46:57 -0400 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200004/73 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.