Using the SQL-standard MERGE statement, a single source row matches more than one target row under the ON condition. What does the standard require PostgreSQL to do?
MERGE INTO target t
USING source s ON t.key = s.key
WHEN MATCHED THEN UPDATE SET val = s.val;