On 14/02/2019 16:11, Tom Lane wrote: > ... so, have we beaten this topic to death yet? Can we make a decision? > > Personally, I'd be happy with either of the last two patch versions > I posted (that is, either AS [[NOT] MATERIALIZED] or > AS [MATERIALIZE [ON|OFF]] syntax). But we gotta pick something.
If we're not really planning to add any more options, I'd register a light vote for MATERIALIZED. It reads easier, seems more grammatically correct, and uses an existing word. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services