Received: from ns1.engrs.org (ns1.engrs.org [216.54.29.10]) by hub.org (8.10.1/8.10.1) with ESMTP id e7NDO0T02491 for ; Wed, 23 Aug 2000 09:24:01 -0400 (EDT) Received: (from uucp@localhost) by ns1.engrs.org (8.9.3/8.9.3) id JAA08200; Wed, 23 Aug 2000 09:37:41 -0400 Received: from UNKNOWN(216.54.52.157), claiming to be "jupiter.greatbridge.com" via SMTP by ns1.engrs.org, id smtpdQH1xM4; Wed Aug 23 13:37:36 2000 Received: (from janwieck@localhost) by jupiter.greatbridge.com (8.9.3/8.9.3) id JAA00959; Wed, 23 Aug 2000 09:27:02 -0500 From: Jan Wieck Message-Id: <200008231427.JAA00959@jupiter.greatbridge.com> Subject: Re: Using SETOF in plpgsql function In-Reply-To: <39A3A268.79F1BC27@lexbase.net> from hlefebvre at "Aug 23, 2000 12:07:36 pm" To: hlefebvre Date: Wed, 23 Aug 2000 09:27:02 -0500 (EST) CC: pgsql-sql@postgresql.org 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: 200008/240 hlefebvre wrote: > Hello, > > I'd like to return a set of integer in an pl/pgsql function. How can I > do that ? You can't. Not with PL/pgSQL nor with any other PL or C. The problem is nested deeper and requires the planned querytree redesign to get solved. Before you ask: The mentioned redesign will NOT be done for 7.1, and I'm not sure if we will be able to do it for 7.2 yet. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== JanWieck@Yahoo.com #