Postgres Pro
Downloads
Home   >   mailing lists

Order of rows in statement triggers NEW/OLD tables - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Order of rows in statement triggers NEW/OLD tables
Date
Msg-id 20220506062017.GA6811@depesz.com
Whole thread Raw
Responses Re: Order of rows in statement triggers NEW/OLD tables
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS
Next
From: Francisco Olarte
Date:
Subject: Re: Psycopg3 fails to resolve 'timezone localtime' on MacOS