Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7F22B633EE6
	for <pgsql-committers-postgresql.org@mail.postgresql.org>;
	Sun,  5 Jul 2009 23:59:05 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 76596-06
	for <pgsql-committers-postgresql.org@mail.postgresql.org>;
	Sun,  5 Jul 2009 23:58:49 -0300 (ADT)
Received: from cvs.postgresql.org (cvs.postgresql.org [217.196.146.206])
	by mail.postgresql.org (Postfix) with ESMTP id 179F6633BC6
	for <pgsql-committers@postgresql.org>;
	Sun,  5 Jul 2009 23:58:50 -0300 (ADT)
Received: by cvs.postgresql.org (Postfix, from userid 1007)
	id 8CB2175331E; Mon,  6 Jul 2009 02:58:48 +0000 (UTC)
MIME-Version: 1.0
To: pgsql-committers@postgresql.org
Subject: pgsql: Per SQL spec (in particular, the grammar in SQL:2008 7.13) we 
X-Mailer: activitymail 1.24, http://search.cpan.org/dist/activitymail/
Content-Type: text/plain
Message-Id: <20090706025848.8CB2175331E@cvs.postgresql.org>
Date: Mon,  6 Jul 2009 02:58:48 +0000 (UTC)
From: tgl@postgresql.org (Tom Lane)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200907/44
X-Sequence-Number: 37647

Log Message:
-----------
Per SQL spec (in particular, the grammar in SQL:2008 7.13) we should allow
parentheses around the <query expression body> that follows a WITH clause, eg
	with cte(foo) as ( values(0) ) ((select foo from cte));
This seems to be just an oversight/thinko in gram.y.  Noted while
experimenting with bug #4902.

Tags:
----
REL8_4_STABLE

Modified Files:
--------------
    pgsql/src/backend/parser:
        gram.y (r2.665 -> r2.665.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.665&r2=2.665.2.1)