Examing cotets of NEW & OLD in a function programed in perl

From: stan <stanb(at)panix(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Examing cotets of NEW & OLD in a function programed in perl
Date: 2020-03-03 17:39:01
Message-ID: 20200303173901.GA5019@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stan 2020-03-03 17:42:48 Re: Detecting which columns a query will modify in a function called by a trigger
Previous Message Christoph Moench-Tegeder 2020-03-03 16:23:46 Re: Perl::DBI and TYPE of column