Peter Eisentraut <peter.eisentr...@2ndquadrant.com> writes: > On 28/01/2019 21:35, Tom Lane wrote: >> Conceivably we could make it work without the parens: >> ...
> Or put it at the end?
> WITH ctename AS ( query ) MATERIALIZED
Yeah, I thought about that too, but it doesn't seem like an improvement.
If the query is very long (which isn't unlikely) I think people would
prefer to see the option(s) up front.
regards, tom lane
