Re: recursive view syntax - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: recursive view syntax
Date
Msg-id 1359689689.29096.3.camel@vanquo.pezone.net
Whole thread Raw
In response to Re: recursive view syntax  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Fri, 2013-01-18 at 10:00 -0500, Stephen Frost wrote:
> I've done another review of this patch and it looks pretty good to me.
> My only complaint is that there isn't a single comment inside
> makeRecursiveViewSelect().

Added some of that and committed.

> One other thought is- I'm guessing this isn't going to work:
> 
> CREATE RECURSIVE VIEW name (columns) AS WITH ... SELECT ...;
> 
> Does the spec explicitly allow or disallow that?  Should we provide any
> comments about it?

That works fine, AFAICT.  It just becomes another level of WITH.





pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: find libxml2 using pkg-config
Next
From: Pavel Stehule
Date:
Subject: Re: parameter info?