Received: from smtp010.mail.yahoo.com (smtp010.mail.yahoo.com [216.136.173.30]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f2FLe0x70454 for ; Thu, 15 Mar 2001 16:40:00 -0500 (EST) (envelope-from janwieck@yahoo.com) Received: from pd957508f.dip.t-dialin.net (HELO jupiter.jw.home) (217.87.80.143) by smtp.mail.vip.sc5.yahoo.com with SMTP; 15 Mar 2001 21:39:56 -0000 X-Apparently-From: Received: (from janwieck@localhost) by jupiter.jw.home (8.9.3/8.9.3) id QAA04163 for pgsql-sql@postgresql.org; Thu, 15 Mar 2001 16:44:39 -0500 From: Jan Wieck Message-Id: <200103152144.QAA04163@jupiter.jw.home> Subject: Re: FETCH ... INTO in PL/pgSQL To: pgsql-sql@postgresql.org Date: Thu, 15 Mar 2001 16:44:38 -0500 (EST) X-Mailer: ELM [version 2.4ME+ PL68 (25)] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Archive-Number: 200103/324 X-Sequence-Number: 1988 Josh Berkus wrote: > Tom, Bruce, > > Is there any way to make use of the contents of a cursor in a PL/pgSQL > function? FETCH ... INTO isn't supported, according to the docs. Can I > use the dot notation, or something similar? PL/pgSQL doesn't support cursors at all. That's basically a fault of the SPI manager because every internal DB access from withing PL/pgSQL is done via SPI and that beast doesn't support cursors. As said, I want to work on that for 7.2. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com # _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com