Mastering PostgreSQL 9.6

Writing triggers in Perl

Every stored procedure language shipped with the core of PostgreSQL allows you to write triggers in that language. The same of course applies to Perl. As the possible length of this chapter is limited, I decided not to include an example of a trigger written in Perl but instead to point you to the official PostgreSQL documentation: https://www.postgresql.org/docs/9.6/static/plperl-triggers.html.

Basically, writing a trigger in Perl does not differ from writing one in PL/pgSQL. All predefined variables are in place, and as far as return values are concerned, the rules apply in every stored procedure language.