On Wed, Jul 25, 2018 at 05:08:43PM +0100, Andrew Gierth wrote: > Nico> It is possible to add a keyword for this purpose in the WITH syntax: > > Nico> WITH VIEW (...) AS a_view > > The existing (and standard) syntax is WITH ctename AS (query).
Oy, I flubbed that up. > Syntaxes that have been suggested for explicitly controlling the > materialization are along the lines of: > > WITH ctename AS [[NOT] MATERIALIZED] (query) > > (MATERIALIZED is already an un-reserved keyword) Works for me.