Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1CKf1x56794 for ; Mon, 12 Feb 2001 15:41:01 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from rhenium (rhenium.btinternet.com [194.73.73.93]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1AB22x40229 for ; Sat, 10 Feb 2001 06:02:02 -0500 (EST) (envelope-from m.proctor@bigfoot.com) Received: from [213.1.165.155] (helo=localhost.localdomain) by rhenium with smtp (Exim 3.03 #83) id 14RXmv-0006Kt-00; Sat, 10 Feb 2001 11:01:57 +0000 From: mark proctor Reply-To: m.proctor@bigfoot.com To: Tom Lane Subject: Re: Recusrive Functions in 7.0.3 Date: Sat, 10 Feb 2001 11:10:05 +0000 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" Cc: pgsql-sql@postgresql.org References: <01020920225704.05071@localhost.localdomain> <01021008430408.05071@localhost.localdomain> <2918.981794531@sss.pgh.pa.us> In-Reply-To: <2918.981794531@sss.pgh.pa.us> MIME-Version: 1.0 Message-Id: <01021011100509.05071@localhost.localdomain> Content-Transfer-Encoding: 8bit X-Archive-Number: 200102/228 X-Sequence-Number: 1419 Ahh I found what I was doing wrong, there was a rogue value being returned causing to infinite loop. Its fixed now. Creating that script you recommended set my thinking process straight. many thanks Mark On Saturday 10 February 2001 08:42, Tom Lane wrote: > mark proctor writes: > > However if I put the PERFORM line back in to create a recursive > > function it just goes on forever, and I only have 6 nodes. > > Hm. There may be a bug here, or maybe you're still confused... but I'm > not eager to reverse-engineer your table declarations and data from this > sketch. Would you mind providing a complete example, ie a SQL script to > reproduce the problem starting from an empty database? > > regards, tom lane