Re: recursive view syntax

From: Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: recursive view syntax
Date: 2012-12-13 12:48:14
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

At 2012-11-13 23:32:15 -0500, peter_e(at)gmx(dot)net wrote:
> 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
> to
> CREATE VIEW name AS WITH RECURSIVE name (columns) AS (SELECT ...)
> SELECT columns FROM name;


Sorry I took so long to post a review of this patch. I'm afraid it
tempted me to digress into figuring out how WITH RECURSIVE works. :-)

I don't have much to say about the patch, though: it applies to HEAD and
builds cleanly, passes "make check", and has suitable documentation with
an example. The code looks fine.

I'm marking it ready for committer.

-- Abhijit

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Karl O. Pinc 2012-12-13 13:05:57 Re: Multiple --table options for other commands
Previous Message Kohei KaiGai 2012-12-13 10:04:53 Re: [v9.3] OAT_POST_ALTER object access hooks