An introduction to triggers in Postgres
Database Trigger Procedure in Postgres
Tag: sql
PostGres: Update Column with Array Values
Update an Array UPDATE users SET topics = '{crows, cats}'; Append an Array UPDATE users SET topics = topics || '{cats,mice}'; Append operation creates duplicates. Reference https://makandracards.com/makandra/36097-postgresql-how-to-add-remove-modify-array-values-and-how-to-replace-1-value-with-multiple-values
