Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 275EEB5DC25
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 16 Jun 2011 16:37:43 -0300 (ADT)
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 10978-01-6 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 16 Jun 2011 19:37:36 +0000 (UTC)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by mail.postgresql.org (Postfix) with ESMTP id 7C62BB5DC45
	for <pgsql-sql@postgresql.org>; Thu, 16 Jun 2011 16:37:09 -0300 (ADT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.14.4/8.14.4) with ESMTP id p5GJb8iI010763
	for <pgsql-sql@postgresql.org>; Thu, 16 Jun 2011 16:37:08 -0300 (ADT)
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.14.4/8.14.4/Submit) id p5GJ7uAx071633
	for pgsql-sql@postgresql.org; Thu, 16 Jun 2011 16:07:56 -0300 (ADT)
	(envelope-from news)
From: Clem Dickey <dickeycl@us.ibm.com>
X-Newsgroups: pgsql.sql
Subject: Re: "<query expression body> ::= <joined table>" grammar rule
	not accepted by Postgres
Date: Thu, 16 Jun 2011 12:07:56 -0700
Organization: Hub.Org Networking Services
Lines: 20
Message-ID: <itdkac$25u0$1@news.hub.org>
References: 
 <OF650DD52B.2DDBF653-ON852578B0.00699C93-882578B0.0077F2AD@us.ibm.com>
	<19449.1308203952@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@news.hub.org
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.17) Gecko/20110428 Fedora/3.1.10-1.fc14 Thunderbird/3.1.10
In-Reply-To: <19449.1308203952@sss.pgh.pa.us>
To: pgsql-sql@postgresql.org
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.51 tagged_above=-5 required=5 tests=BAYES_05=-0.5,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201106/62
X-Sequence-Number: 35528

On 06/15/2011 10:59 PM, Tom Lane wrote:
> Clem Dickey<dickeycl@us.ibm.com>  writes:
>> This expression is (I think) a well-formed query, but is rejected by
>> Postgresql 8.4 (t is a table name).
>
>>    t t1 NATURAL JOIN t t2;
>
> Hmm ... I think you are looking at SQL92 or SQL99.

> [ digs a bit more... ]  Ah, here we are: Annex E of SQL:2003 calls out
> various incompatibilities from SQL:99, notably
>
> 	6) In ISO/IEC 9075-2:1999, a<query expression body>,<query
> 	term>, or<query primary>  could consist of a<joined
> 	table>. None of those three elements can consist of a<joined
> 	table>  in this edition of ISO/IEC 9075.

Thanks for the research. I was indeed reading from SQL99, which was 
current the last time I used SQL. I'll have to spring for a newer 
standard (or the equivalent).