Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 871E46339A7
	for <pgsql-committers-postgresql.org@mail.postgresql.org>;
	Sun,  5 Jul 2009 23:58:47 -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-05
	for <pgsql-committers-postgresql.org@mail.postgresql.org>;
	Sun,  5 Jul 2009 23:58:42 -0300 (ADT)
Received: from cvs.postgresql.org (cvs.postgresql.org [217.196.146.206])
	by mail.postgresql.org (Postfix) with ESMTP id BC4E7633AB7
	for <pgsql-committers@postgresql.org>;
	Sun,  5 Jul 2009 23:58:42 -0300 (ADT)
Received: by cvs.postgresql.org (Postfix, from userid 1007)
	id EBF6B75331E; Mon,  6 Jul 2009 02:58:40 +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: <20090706025840.EBF6B75331E@cvs.postgresql.org>
Date: Mon,  6 Jul 2009 02:58:40 +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/43
X-Sequence-Number: 37646

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.

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