From derby-user-return-14676-apmail-db-derby-user-archive=db.apache.org@db.apache.org Sun Oct 14 17:56:07 2012 Return-Path: X-Original-To: apmail-db-derby-user-archive@www.apache.org Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E2245DC02 for ; Sun, 14 Oct 2012 17:56:06 +0000 (UTC) Received: (qmail 57143 invoked by uid 500); 14 Oct 2012 17:56:06 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 57116 invoked by uid 500); 14 Oct 2012 17:56:06 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 57106 invoked by uid 99); 14 Oct 2012 17:56:06 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 14 Oct 2012 17:56:06 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [98.139.91.222] (HELO nm22-vm0.bullet.mail.sp2.yahoo.com) (98.139.91.222) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 14 Oct 2012 17:55:59 +0000 Received: from [72.30.22.77] by nm22.bullet.mail.sp2.yahoo.com with NNFMP; 14 Oct 2012 17:55:38 -0000 Received: from [98.139.44.88] by tm11.bullet.mail.sp2.yahoo.com with NNFMP; 14 Oct 2012 17:55:37 -0000 Received: from [127.0.0.1] by omp1025.access.mail.sp2.yahoo.com with NNFMP; 14 Oct 2012 17:55:37 -0000 X-Yahoo-Newman-Id: 974367.99803.bm@omp1025.access.mail.sp2.yahoo.com Received: (qmail 4651 invoked from network); 14 Oct 2012 17:55:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=sbcglobal.net; h=DKIM-Signature:X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=5yQC9VEeMH1QxSLnF6d3IYug6yG5iSlHVn319W3kilH0NqAF/6WGoNnoKZ72qS3bVG+iVx4wyLXzMKHrvTtGDnwgCtriZmc5SGGqmaCK71bKEf17vjSYUAWq/9uHfFiB0zVVByt39MLU3Oc3dkbk/CBPFpJxVxmVw5dPW23hUvY= ; DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sbcglobal.net; s=s1024; t=1350237337; bh=y/xZqTLR67fgeKBKi6xW6diEMXALekwceyA6r7sBg1g=; h=X-Yahoo-Newman-Property:X-YMail-OSG:X-Yahoo-SMTP:Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=tu5XLubpszY3rx3nRZAUlgX1711l7hx0mbazgJ1yCyp232P02/5NH2Ela5jbPgWCUM5ijQKO477iq/9ERii1wctdiq5h6pOluLGV2XFRgCphI2Ny315sA5ZXF3TJeHs3xjk9OilWnBPCljmvnUhXbaLQGuZblQw+mBlGlcj49AA= X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: jCxxxjoVM1k.QfJOQErUXFwAZR71oyqSw1OfO4FwhvRfKg7 JkQT6lkPOYQHRmSHU3FBEvCOmJA0lwwpC_Zvvg4owqWPeag827IWx_z.1fOn DfHxMcB.FxBUvyGbAUqy6b0so2AKv60V5nk7X0de0QA0SGerFvzROmYvjfa9 ZURB42uRYjSjugHDEJ.gwl9_v0KR2mwqVzMCVNnUrmMbsGnY8Tlf98OKLoDi UnP82UjL4z7uAIOkvGBzsRLysnw0YaiVi1oP9PmAPm1HvTx7Q0neXbwfeZez kpx1EH9sbCGXugBaWod4KoX7jmOVT76JA5XKpyPSMr5nmnXMsVT63B57.zRZ Qf7K4w7ufQTgK4dFZGygMa3vtZLIBPt_9g9ZaKE2qdJDGUZn7MAOUwYt2GGD Gtiea.b086c.zxCe8b8nJ1w2JRWee6nsFGGUtt5szPdn.E0ZR75K2Bd8jr1B 7B.byWVgXqXU7_GmnNZeBkar3E_E7mcKRvmYaNiLrPPWH_9jeQXaFrLJ3rkN 4e2bO8PJIylufSbSFwF4H3XKIYDwKEHvmS5mQm4C60hw9WvV6Yw.Q3rfcI_Y rQT0jQC2lYvZZE3LWL6LhlCzebGzSNUiS26lkQqOpfVdiedmko4by6dbeD6f AAwmXKELzflkqKWXoxzZjGxaOWYUYu7suyrm3QHpumKRikCj4pOMjAe3E949 rYW8XOelFPbfIP8LrlyonkSON4HnNrYZC4BShTQrQKvpkbp0uai.5j3xzvJo i X-Yahoo-SMTP: fBd8VESswBBwVkX.d9lIdXduzED_6kJxUAzIjM21tL._95FbORG0yg-- Received: from [192.168.1.71] (kmarsdenderby@108.231.78.45 with plain) by smtp112.sbc.mail.gq1.yahoo.com with SMTP; 14 Oct 2012 10:55:37 -0700 PDT Message-ID: <507AFC97.1070405@sbcglobal.net> Date: Sun, 14 Oct 2012 10:55:35 -0700 From: Katherine Marsden User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121010 Thunderbird/16.0.1 MIME-Version: 1.0 To: Derby Discussion Subject: Re: Getting transitive closure? References: <507AA78C.7050003@gmail.com> <507ABF7A.3050209@gmail.com> In-Reply-To: <507ABF7A.3050209@gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Checked: Checked by ClamAV on apache.org On 10/14/2012 6:34 AM, John English wrote: > 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... :-) > Doesn't help right now, but you may also wish to vote for https://issues.apache.org/jira/browse/DERBY-11. This was an early request but I think pretty hard to implement and I am not sure if there is a SQL standard syntax.