On 2022-Aug-12, Simon Riggs wrote: > Sorry, but I disagree with this chunk in the latest commit, > specifically, changing the MATCHED from after to before the NOT > MATCHED clause. > > The whole point of the second example was to demonstrate that the > order of the MATCHED/NOT MATCHED clauses made no difference. > > By changing the examples so they are the same, the sentence at line > 573 now makes no sense.
Hmm, I thought the point of the example was to show that you can replace the table in the USING clause with a query that retrieves the column; but you're right, we lost the thing there. Maybe it was too subtle to the point that I failed to understand it. Perhaps we can put it back the way it was and explain these two differences (change of data source *and* clause ordering) more explicitly. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "La virtud es el justo medio entre dos defectos" (Aristóteles)