Re: Poor performance using CTE

On 22/11/2012 00:08, Craig Ringer wrote:
> WITH
>    FENCE foo AS (SELECT ...),
>    bar AS (SELECT ...)
> SELECT * FROM bar;
>
> Are we fencing just foo? Or all expressions?
>

WITH foo AS (FENCED SELECT ...),
      bar AS (SELECT ...),
SELECT ... ;

--
Jeremy