43.10 Trigger Functions one sentences kind of not easy to understand.

From: Jian He <hejian(dot)mark(at)gmail(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: 43.10 Trigger Functions one sentences kind of not easy to understand.
Date: 2022-04-27 11:39:01
Message-ID: CAMV54g3BuwvPqB7x+EWZX8fUCL=FYxdk1c0VG4ZiZ6HeCPxP4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

https://www.postgresql.org/docs/current/plpgsql-trigger.html

>
> Row-level triggers fired BEFORE can return null to signal the trigger
> manager to skip the rest of the operation for this row (i.e., subsequent
> triggers are not fired, and the INSERT/UPDATE/DELETE does not occur for
> this row). If a nonnull value is returned then the operation proceeds with
> that row value. *Returning a row value different from the original value
> of NEW alters the row that will be inserted or updated. *Thus, if the
> trigger function wants the triggering action to succeed normally without
> altering the row value, NEW (or a value equal thereto) has to be
> returned. To alter the row to be stored, it is possible to replace single
> values directly in NEW and return the modified NEW, or to build a
> complete new record/row to return. In the case of a before-trigger on
> DELETE, the returned value has no direct effect, but it has to be nonnull
> to allow the trigger action to proceed. Note that NEW is null in DELETE
> triggers, so returning that is usually not sensible. The usual idiom in
> DELETE triggers is to return OLD.
>

I just want confirm the highlighted sentence is equivalent as the
following sql code:

begin;
> CREATE TABLE documents (
> docdesc text,
> misc text,
> modification_time timestamp with time zone DEFAULT now()
> );
> CREATE FUNCTION documents_update_mod_time() RETURNS trigger
> AS $$
> begin
> new.modification_time := now();
>
return new;
>
end
> $$
> LANGUAGE plpgsql;
> CREATE TRIGGER documents_modification_time
> BEFORE INSERT OR UPDATE ON documents
> FOR EACH ROW
> EXECUTE PROCEDURE documents_update_mod_time();
> commit;
>

as a non-native english speaker, I kind of feel this sentence quite hard to
understand....

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Alvaro Herrera 2022-04-27 11:46:05 Re: 43.10 Trigger Functions one sentences kind of not easy to understand.
Previous Message David G. Johnston 2022-04-20 20:52:38 Re: 'CREATE OR REPLACE FUNCTION' behavior whenever a transaction is running