Re: CTE optimization fence on the todo list? - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: CTE optimization fence on the todo list?
Date
Msg-id CAEYLb_WUiP7kNR1xv3UWXhukfdFL-nCC05eyog=17ghX+z0DJw@mail.gmail.com
Whole thread Raw
In response to Re: CTE optimization fence on the todo list?  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-hackers
On 1 October 2012 14:05, Merlin Moncure <mmoncure@gmail.com> wrote:
> On Wed, Sep 19, 2012 at 3:05 PM, Daniel Browning <db@kavod.com> wrote:
> I'm wondering if there are any technical/standards constraints that
> are behind the fencing behavior.  If there aren't any, maybe an opt-in
> keyword might do the trick -- WITH UNBOXED foo AS (..)?

I may be mistaken, but I think that the fence is described in the SQL standard.

-- 
Peter Geoghegan       http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services



pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: CTE optimization fence on the todo list?
Next
From: Peter Eisentraut
Date:
Subject: Re: embedded list v3