Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 786734761E2 for ; Tue, 6 Aug 2002 12:54:53 -0400 (EDT) Received: from wolff.to (wolff.to [66.92.219.49]) by postgresql.org (Postfix) with SMTP id 9613E47614D for ; Tue, 6 Aug 2002 12:54:50 -0400 (EDT) Received: (qmail 7179 invoked by uid 500); 6 Aug 2002 17:01:31 -0000 Date: Tue, 6 Aug 2002 12:01:31 -0500 From: Bruno Wolff III To: Oleg Bartunov Cc: Dan Langille , Suhas Joshi , pgsql-sql@postgresql.org Subject: Re: Transitive Closure Message-ID: <20020806170131.GA7103@wolff.to> Mail-Followup-To: Oleg Bartunov , Dan Langille , Suhas Joshi , pgsql-sql@postgresql.org References: <3D4FABFE.18755.17ABC352@localhost> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.25i X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/109 X-Sequence-Number: 8955 On Tue, Aug 06, 2002 at 20:34:11 +0300, Oleg Bartunov wrote: > > in psql or pgsql ? I know 'transitive closure' for graph-like structure Postgres doesn't provide a general way to get the transitive closure for a relation. There is a comment in the todo file that appears to cover this, but it isn't something that is likely to be done soon. Depending on what the person wanted to do, there may be a way to solve his problem. However the person asking the question didn't provide that information, so it is hard to give him any specific advice.