Create trigger in postgressql
A personal identity codes consist of a string of numbers that indicates the individual’s date of birth, an individualized string, and a control character.
Examples: 150600A905P
Syntax error on creating trigger function in PostgreSQL
I use the next script to create trigger function in PostgreSQL:
postgresql extension function does not exist inside trigger
I have installed pgsodium into the database using CREATE EXTENSION pgsodium.
This is the output from dx
Correct a postgresql trigger to audit every changers happen a single row
I put my code bellow. In this code only one update for one row makes a record in MAUDACTIVITYEVENTS table. If did two changers in same row only first change makes the trigger runs and create the record but if i did the changers in two rows two records creates in the MAUDACTIVITYEVENTS table how can I fix this so every update in a single row makes an audit.