Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 9DA924754A3 for ; Mon, 19 Aug 2002 10:52:51 -0400 (EDT) Received: from mail.iinet.net.au (mail-03.iinet.net.au [203.59.3.35]) by postgresql.org (Postfix) with SMTP id A42AA47614E for ; Mon, 19 Aug 2002 10:52:48 -0400 (EDT) Received: (qmail 9702 invoked from network); 19 Aug 2002 14:52:46 -0000 Received: from unknown (HELO SOL) (203.59.159.124) by mail.iinet.net.au with SMTP; 19 Aug 2002 14:52:46 -0000 Message-ID: <006b01c24790$072149c0$0200a8c0@SOL> From: "Christopher Kings-Lynne" To: "Fritz Lehmann-Grube" , References: <3D60F041.10003@math.tu-berlin.de> Subject: Re: recursive function returning "setof" Date: Mon, 19 Aug 2002 22:52:22 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/267 X-Sequence-Number: 9113 > The problem is: > A SQL-Function cannot be recursive because it cannot call itself, and it can > perform no loops. > A PLPGSQL-Function cannot return sets. It can perform loops. Check the manual- you can do FOR and WHILE loops. 7.3 will be able to return sets from PLPGSQL funcs it seems. Chris