Are there variables like NEW and OLD in statement level triggers?

Question

PostgreSQL

NEW
Data type RECORD. The variable contains the new database row for INSERT/UPDATE commands in row-level triggers. In statement-level triggers and for the DELETE command, this variable is not assigned a value.

OLD
Data type RECORD. The variable contains the old database row for UPDATE/DELETE commands in row level triggers. In statement-level triggers and for the INSERT statement, this variable is not assigned a value.

is there something similar for operator level triggers? so that all the affected lines are stored in some variable?

Answer 1

Yes, for AFTER STATEMENT triggers there is :

CREATE TRIGGER transfer_insert
    AFTER UPDATE ON transfer
    REFERENCING NEW TABLE AS newtab OLD TABLE AS oldtab
    FOR EACH STATEMENT
    EXECUTE FUNCTION check_transfer_balances_to_zero();

In the check_transfer_balances_to_zero function, the newtab and oldtab tables will be available.
(According to the documentation, REFERENCING can also be specified for ROW triggers. I don’t know how it works in this case)