On 07/25/2018 06:08 PM, Andrew Gierth wrote:
WITH ctename AS [[NOT] MATERIALIZED] (query)
I think "NOT MATERIALIZED" would be a bit misleading since the planner may choose to materialize anyway, so I suggest skipping that part of the syntax unless there is a really strong reason for having it.
Andreas