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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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