Does specifying CALLED ON NULL INPUT, RETURNS NULL ON NULL INPUT or STRICT (https://www.postgresql.org/docs/current/static/sql-createfunction.html) on a trigger procedure in PostgreSQL do anything?

Since a trigger procedure must be declared as a function with no arguments (https://www.postgresql.org/docs/current/static/plpgsql-trigger.html), I doubt it has any effect but I cannot find a definite answer on this one.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.