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.