On Wed, Feb 1, 2023 at 10:18 PM Alvaro Herrera <alvherre@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=mwdFdAGw@mail.gmail.com
