From: Clem Dickey <dickeycl@us.ibm.com>
To: pgsql-sql@postgresql.org
Subject: Re: "<query expression body> ::= <joined table>" grammar rule not accepted by Postgres
Date: Thu, 16 Jun 2011 12:07:56 -0700
Message-ID: <itdkac$25u0$1@news.hub.org> (raw)
In-Reply-To: <19449.1308203952@sss.pgh.pa.us>
References: <OF650DD52B.2DDBF653-ON852578B0.00699C93-882578B0.0077F2AD@us.ibm.com>
<19449.1308203952@sss.pgh.pa.us>
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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dickeycl@us.ibm.com
Subject: Re: "<query expression body> ::= <joined table>" grammar rule not accepted by Postgres
In-Reply-To: <itdkac$25u0$1@news.hub.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox