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

From: stan <stanb(at)panix(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Examing cotets of NEW & OLD in a function programed in perl
Date: 2020-03-03 21:26:01
Message-ID: 20200303212601.GA6469@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Mar 03, 2020 at 12:59:00PM -0500, Tom Lane wrote:
> stan <stanb(at)panix(dot)com> writes:
> > 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.
>
> AFAIR, they're just hashes in Perl, so you should be able to do
> stuff like iterating over the hash keys.
>
> regards, tom lane

So, they should just be visible as OLD, and NEW as hasshes?

Sorry for my lack of understnading.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christophe Pettus 2020-03-03 21:28:14 Re: Examing cotets of NEW & OLD in a function programed in perl
Previous Message Alvaro Herrera 2020-03-03 20:58:41 Re: Exportacion por lotes