Received: from mx2.imaginet.fr (artemis.imaginet.fr [195.68.75.24]) by hub.org (8.10.1/8.10.1) with ESMTP id e7N9rOT32312 for ; Wed, 23 Aug 2000 05:53:24 -0400 (EDT) Received: from lexbase.net ([195.68.125.34]) by mx2.imaginet.fr (8.9.3/8.8.8) with ESMTP id LAA07057 for ; Wed, 23 Aug 2000 11:51:49 +0200 (MET DST) Message-ID: <39A3A268.79F1BC27@lexbase.net> Date: Wed, 23 Aug 2000 12:07:36 +0200 From: hlefebvre Organization: LEXBASE X-Mailer: Mozilla 4.73 [en] (WinNT; U) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Using SETOF in plpgsql function References: <200008230946.e7N9kPT30420@hub.org> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/235 Hello, I'd like to return a set of integer in an pl/pgsql function. How can I do that ? I've tried things like that, put I've an error when executing : CREATE FUNCTION SP_UPLES() RETURNS setof INTEGER AS ' DECLARE ID INTEGER; BEGIN select a into id from foo; return ID ; END; CREATE FUNCTION SP_UPLES() RETURNS setof INTEGER AS ' DECLARE ID setof INTEGER; BEGIN select a into id from foo; return ID ; END; CREATE FUNCTION SP_UPLES() RETURNS setof INTEGER AS ' BEGIN select a into id from foo; return select a from foo; END; Any help is welcomed. Thanks.