Skip site navigation (1) Skip section navigation (2)

Re: recursive view syntax

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: recursive view syntax
Date: 2013-02-01 03:34:49
Message-ID: 1359689689.29096.3.camel@vanquo.pezone.net (view raw or flat)
Thread:
Lists: 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.




In response to

pgsql-hackers by date

Next:From: Pavel StehuleDate: 2013-02-01 04:02:35
Subject: Re: parameter info?
Previous:From: Peter EisentrautDate: 2013-02-01 03:17:02
Subject: Re: find libxml2 using pkg-config

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group