In this episode of Scaling Postgres, we discuss implementing row level triggers, how to return dynamic columns using pl/pgsql, and when to use citext.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://pganalyze.com/blog/custom-postgres-data-types-ruby-rails

https://www.cybertec-postgresql.com/en/what-to-return-from-a-postgresql-row-level-trigger/

https://www.depesz.com/2021/04/21/getting-value-from-dynamic-column-in-pl-pgsql-triggers/

https://www.youtube.com/watch?v=iq8sUHYilPk

https://www.highgo.ca/2021/04/22/hash-index-internals/

https://www.highgo.ca/2021/04/19/calling-stored-procedure-from-java-part-2/

https://pgsqlpgpool.blogspot.com/2021/04/visibility-with-query-cache.html

https://postgresql.life/post/pavlo_golub/