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

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

From

tgl@postgresql.org (Tom Lane)

Date:

05 July 2009, 23:58:48

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)