Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by postgresql.org (Postfix) with ESMTP id 058FC4759BB for ; Fri, 22 Mar 2002 11:23:05 -0500 (EST) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 16oRor-000Pv6-0X; Fri, 22 Mar 2002 16:23:09 +0000 Received: from there (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 2A95113E6F; Fri, 22 Mar 2002 16:15:20 +0000 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: Richard Huxton To: "Ivan Babikov" , pgsql-sql@postgresql.org Subject: Re: How to return more than one variable from PgPlSQL procedure? Date: Fri, 22 Mar 2002 16:15:06 +0000 X-Mailer: KMail [version 1.3.1] References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20020322161520.2A95113E6F@mainbox.archonet.com> X-Archive-Number: 200203/288 X-Sequence-Number: 7167 On Friday 22 Mar 2002 12:34, Ivan Babikov wrote: > Hello all, > > I've noticed that postgres functions can return SETOF but it seems that > SETOF works only for sql-language functions. At least the code below is > compilable but causes freezing of pgAdmin during the execution. This > function was converted to PgPlSql from Interbase: Your assessment is correct, plpgsql cannot cope with SETOF at the moment. Version 7.2 allows you to return a cursor though (see the docs). - Richard Huxton