General Trigger Functions

From: mjp(at)ornl(dot)gov
To: pgsql-general(at)postgresql(dot)org
Subject: General Trigger Functions
Date: 2000-07-25 19:46:38
Message-ID: 20000725154638.B8384@grail.lsd.ornl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is there a way to write a "generic" trigger function in postgres
that can loop thru a table's cloumns (using TG_RELNAME)
and perform certain activities based on, say, certain column-types?
In other words, is it possible to assign OLD.<column_name>
and NEW.<column_name> to a variable inside triggers?

Thanks,
Morey Parang
ORNL

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2000-07-25 20:39:53 RE: Describe structure.
Previous Message Jan Wieck 2000-07-25 19:07:01 Re: Comment #line after pre-processing