Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 7FEFD133740B for ; Wed, 1 Dec 2010 22:38:35 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 79919-01 for ; Thu, 2 Dec 2010 02:38:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [69.36.227.170]) by mail.postgresql.org (Postfix) with ESMTP id EA7471335B36 for ; Wed, 1 Dec 2010 22:38:27 -0400 (AST) Received: from dsl081-245-111.sfo1.dsl.speakeasy.net ([64.81.245.111] helo=Sidney-Stratton.local) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:CAMELLIA256-SHA:256) (Exim 4.69) (envelope-from ) id 1PNz3m-0008OS-7C; Wed, 01 Dec 2010 18:38:17 -0800 Message-ID: <4CF70690.6050703@agliodbs.com> Date: Wed, 01 Dec 2010 18:38:08 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: Jim Nasby CC: Andrew Dunstan , Tom Lane , ghatpande@vsnl.net, Dann Corbit , pgsql hackers Subject: Re: Proposal: First step towards Intelligent, integrateddatabase References: <87F42982BF2B434F831FCEF4C45FC33E4209B193@EXCHANGE.corporate.connx.com> <15327.1291214468@sss.pgh.pa.us> <4CF662C5.70109@dunslane.net> <4FDE4580-04F7-4530-BDBE-078BD91321AA@nasby.net> In-Reply-To: <4FDE4580-04F7-4530-BDBE-078BD91321AA@nasby.net> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201012/126 X-Sequence-Number: 175388 > Something that did what Pavel mentioned: > > SELECT name, parent->name FROM children; > > would be very useful. It means you no longer have to write explicit joins (or perhaps more accurately, you no longer have to specify exactly how to join the two tables). Already exists: http://htsql.org/ -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com