Post #1070 1.98K Oct 15, 2022, 10:01 UTC In short, about MERGE in just released Postgres 15: https://twitter.com/samokhvalov/status/1580935490580058112 Twitter Two things MERGE lacks now: - RETURNING clause to allow user to see what exactly was done and save on RTT - WHEN NOT MATCHED BY [SOURCE|TARGET] to allow easy syncing with source - e.g., ETL The former is postgresism, the latter is what SQL Server has (but…