Re: [GENERAL] A trigger that acts on a column with a given column

2005-07-11 Thread Karl O. Pinc
On 07/07/2005 02:28:23 PM, BigSmoke wrote: In a trigger function, I'm trying to refer to a column given by an argument to the trigger function. I sometimes have a tendency to use the m4 macro processor to write different trigger functions with the correct column name substituted in where appro

Re: [GENERAL] A trigger that acts on a column with a given column name

2005-07-07 Thread BigSmoke
On 7/7/05, Michael Fuhr <[EMAIL PROTECTED]> wrote: > On Thu, Jul 07, 2005 at 09:28:23PM +0200, BigSmoke wrote: > > > > In a trigger function, I'm trying to refer to a column given by an argument > > to the trigger function. > > This comes up frequently -- search the archives for past discussion. >

Re: [GENERAL] A trigger that acts on a column with a given column name

2005-07-07 Thread Michael Fuhr
On Thu, Jul 07, 2005 at 09:28:23PM +0200, BigSmoke wrote: > > In a trigger function, I'm trying to refer to a column given by an argument > to the trigger function. This comes up frequently -- search the archives for past discussion. The usual answer is to write the function in a language like PL/

[GENERAL] A trigger that acts on a column with a given column name

2005-07-07 Thread BigSmoke
In a trigger function, I'm trying to refer to a column given by an argument to the trigger function. The trigger function fires on deletes and is responsible for deleting messages that are referred to using foreign keys which are named differently in different tables (thus the foreign key's column