Order of rows in statement triggers NEW/OLD tables

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Order of rows in statement triggers NEW/OLD tables
Date: 2022-05-06 06:20:17
Message-ID: 20220506062017.GA6811@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
when defining statement triggers on update I can use:

REFERENCING OLD TABLE AS xxx NEW TABLE as YYY

these "pseudo" tables contain rows that were before and after.

Is the order guaranteed?

Can I assume that "first" row returned by select from xxx, will be older
version of first row returned by select from yyy?

depesz

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2022-05-06 09:01:06 Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
Previous Message Jerry Sievers 2022-05-06 02:11:55 Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS