Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of john.foreign@gmail.com
 designates 209.85.215.172 as permitted sender)
Message-ID: <507ABF7A.3050209@gmail.com>
Date: Sun, 14 Oct 2012 15:34:50 +0200
From: John English <john.foreign@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:15.0) Gecko/20120907 Thunderbird/15.0.1
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Re: Getting transitive closure?
References: <507AA78C.7050003@gmail.com>
 <CAAixLiTshWv12ppNKdnLV8XXMR1sO3XgFkk57E+W6mRsjLA_eA@mail.gmail.com>
In-Reply-To: 
 <CAAixLiTshWv12ppNKdnLV8XXMR1sO3XgFkk57E+W6mRsjLA_eA@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

On 14/10/2012 14:45, Jos� Ventura wrote:
> I might be mistaken, but I think Derby does not support this
> out-of-the-box. There are, however, a few interesting solutions
> suggested in this (2009) thread:
>
> http://old.nabble.com/Recursive-query-on-common-table-td25819772.html

Thanks! I'm now in the process or recursively trying to construct the 
transitive closure of all the possible approaches that this page links 
to... :-)

-- 
John English