Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 7BD4347773D for ; Wed, 15 Jan 2003 16:34:58 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id 5814747641C for ; Wed, 15 Jan 2003 15:40:34 -0500 (EST) Received: (qmail 17285 invoked by uid 500); 15 Jan 2003 20:52:49 -0000 Date: Wed, 15 Jan 2003 14:52:49 -0600 From: Bruno Wolff III To: Matthew Nuzum Cc: pgsql-sql@postgresql.org Subject: Re: lost on self joins Message-ID: <20030115205249.GB16969@wolff.to> Mail-Followup-To: Matthew Nuzum , pgsql-sql@postgresql.org References: <002d01c2bcc4$17e487a0$6700a8c0@mattspc> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <002d01c2bcc4$17e487a0$6700a8c0@mattspc> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/239 X-Sequence-Number: 11104 On Wed, Jan 15, 2003 at 13:29:47 -0500, Matthew Nuzum wrote: > > Can anyone suggest a way for me to get the information I need? I'm very > content to use a simple pl/pgsql function, however I don't know how I'd > use recursion there. Look at the tablefunc contrib package. I believe it provides the ability to do what you are trying to do. You might need to have 7.3 to have it available.