Received: from ruthenium ([194.73.73.138]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f19KEsx35363 for ; Fri, 9 Feb 2001 15:14:54 -0500 (EST) (envelope-from m.proctor@bigfoot.com) Received: from [213.1.144.208] (helo=localhost.localdomain) by ruthenium with smtp (Exim 3.03 #83) id 14RJwR-0004BD-00 for pgsql-sql@postgresql.org; Fri, 09 Feb 2001 20:14:51 +0000 From: Reply-To: m.proctor@bigfoot.com To: Subject: Recusrive Functions in 7.0.3 Date: Fri, 9 Feb 2001 20:22:57 +0000 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" MIME-Version: 1.0 Message-Id: <01020920225704.05071@localhost.localdomain> Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/177 X-Sequence-Number: 1363 Are recursive functions allowed in in 7.0.3 as I seem to be unable to get them to work in plpgsql, it just freezes and I have to do ctrl-alt-c. ie calling the same function name from within some form of loop, possible to 4 or 5 levels? Also is it possible to output any debugging info, all I really want to be able to do is print out a variable to the screen. Final quesion for pure speed on functions does PL/PGSQL have special compilation options or would I get better performace for PL/C? Regards Mark