pgsql: Add CREATE RECURSIVE VIEW syntax

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add CREATE RECURSIVE VIEW syntax
Date: 2013-02-01 03:33:05
Message-ID: E1U17NB-0006c6-DX@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add CREATE RECURSIVE VIEW syntax

This is specified in the SQL standard. The CREATE RECURSIVE VIEW
specification is transformed into a normal CREATE VIEW statement with a
WITH RECURSIVE clause.

reviewed by Abhijit Menon-Sen and Stephen Frost

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/583905269378bf41c24585773885b1e226a998ce

Modified Files
--------------
doc/src/sgml/ref/create_view.sgml | 29 ++++++++++++-
src/backend/parser/gram.y | 85 ++++++++++++++++++++++++++++++++++++
src/test/regress/expected/with.out | 30 +++++++++++++
src/test/regress/sql/with.sql | 15 ++++++
4 files changed, 158 insertions(+), 1 deletions(-)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2013-02-01 13:50:02 pgsql: Fill tuple before HeapSatisfiesHOTAndKeyUpdate
Previous Message Peter Eisentraut 2013-02-01 03:10:57 pgsql: PL/Tcl: Fix compiler warnings with Tcl 8.6