mjp@ornl.gov wrote:
> 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?
PL/pgSQL has the pseudo type RECORD. And at least it'd be
possible with PL/Tcl.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #