>>>>> "Nico" == Nico Williams <n...@cryptonector.com> writes:
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). 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) -- Andrew (irc:RhodiumToad)