recursive view syntax - Mailing list pgsql-hackers

From Peter Eisentraut
Subject recursive view syntax
Date
Msg-id 1352867535.26167.8.camel@vanquo.pezone.net
Whole thread Raw
Responses Re: recursive view syntax  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: recursive view syntax  (Abhijit Menon-Sen <ams@2ndQuadrant.com>)
Re: recursive view syntax  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
I noticed we don't implement the recursive view syntax, even though it's
part of the standard SQL feature set for recursive queries.  Here is a
patch to add that.  It basically converts

CREATE RECURSIVE VIEW name (columns) AS SELECT ...;

to

CREATE VIEW name AS WITH RECURSIVE name (columns) AS (SELECT ...) SELECT
columns FROM name;


Attachment

pgsql-hackers by date:

Previous
From: Ants Aasma
Date:
Subject: Re: Further pg_upgrade analysis for many tables
Next
From: Tom Lane
Date:
Subject: Re: recursive view syntax