Examing cotets of NEW & OLD in a function programed in perl - Mailing list pgsql-general

From stan
Subject Examing cotets of NEW & OLD in a function programed in perl
Date
Msg-id 20200303173901.GA5019@panix.com
Whole thread Raw
Responses Re: Examing cotets of NEW & OLD in a function programed in perl  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I need to write a generic function to process data before allowing the
insert or update to continue.

To do this, I need to be able to examine the NEW, and OLD structures
without prior knowledge of the structure of the table that fired the
trigger.

Can someone show me an example of how to get these structures into
something I can work with in Perl?


-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin



pgsql-general by date:

Previous
From: Christoph Moench-Tegeder
Date:
Subject: Re: Perl::DBI and TYPE of column
Next
From: stan
Date:
Subject: Re: Detecting which columns a query will modify in a function calledby a trigger