On Wed, Feb 1, 2023 at 10:18 PM Alvaro Herrera <alvhe...@alvh.no-ip.org> wrote: > Earlier today I gave a talk about MERGE and wanted to provide an example > with FOR EACH STATEMENT triggers using transition tables. However, I > can't find a non-ugly way to obtain the NEW row that corresponds to each > OLD row ... I had to resort to an ugly trick with OFFSET n LIMIT 1. > Can anyone suggest anything better? I couldn't find any guidance in the > docs.
I don't know the answer, either in PostgreSQL or the SQL spec. I wondered if there *should* be a way here: https://www.postgresql.org/message-id/CAEepm=1ncxBNna-pXGr2hnMHRyYi_6_AwG_352-Jn=mwdfd...@mail.gmail.com