Andreas Karlsson <andreas@proxel.se> writes:
> On 1/11/19 8:10 PM, Robert Haas wrote:
>> WITH cte_name [[NOT] MATERIALIZED] AS (query) main_query...
> Hm, when would one want "NOT MATERIALIZED"? I am not sure I see the
> usefulness of forcing inlining other than if we by default do not inline
> when a CTE is referenced multiple times.
I'm also concerned about what we do if the user says NOT MATERIALIZED
but there are semantic or implementation reasons not to inline. Either
we throw an error or do something the user didn't expect, and neither
is very nice. So I'm not in favor of having that option.
regards, tom lane