Skip site navigation (1) Skip section navigation (2)

pgsql: Per SQL spec (in particular, the grammar in SQL:2008 7.13) we

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Per SQL spec (in particular, the grammar in SQL:2008 7.13) we
Date: 2009-07-06 02:58:48
Message-ID: 20090706025848.8CB2175331E@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
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)

pgsql-committers by date

Next:From: User AchernowDate: 2009-07-06 03:41:23
Subject: libpqtypes - libpqtypes: add PQsendf and PQsendvf
Previous:From: Tom LaneDate: 2009-07-06 02:58:40
Subject: pgsql: Per SQL spec (in particular, the grammar in SQL:2008 7.13) we

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group