| From: | JanWieck(at)t-online(dot)de (Jan Wieck) |
|---|---|
| To: | mjp(at)ornl(dot)gov |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: General Trigger Functions |
| Date: | 2000-07-25 20:54:04 |
| Message-ID: | 200007252054.WAA21428@hot.jw.home |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
mjp(at)ornl(dot)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(at)Yahoo(dot)com #
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Burton | 2000-07-25 21:03:52 | (Fwd) RE: PostgreSQL, ODBC, Access (solution for me) |
| Previous Message | Peter Eisentraut | 2000-07-25 20:40:51 | Re: 4 billion record limit? |