Is it necessary to return NEW or is NULL sufficient? Has it any meaning to return anything in an AFTER trigger?

  • 2
    I'm no expert on Postgres triggers (in fact I found them somewhat counter-intuitive) but to my limited knowledge RETURN is only relevant for BEFORE triggers. For AFTER triggers the result is ignored: postgresql.org/docs/current/plpgsql-trigger.html Apr 3 at 8:18
  • 1
    @Lennart-SlavaUkraini Thanks! I found it. I was searching on the create trigger page, which was the wrong place.
    – ceving
    Apr 3 at 8:23


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.