Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 56598475E7C for ; Wed, 12 Jun 2002 03:45:36 -0400 (EDT) Received: from smtpp.cnamts.fr (unknown [195.6.127.73]) by postgresql.org (Postfix) with SMTP id 0EB77475DCD for ; Wed, 12 Jun 2002 03:45:35 -0400 (EDT) Received: from hermes1.cpam-cergypontoise.cnamts.fr ([55.168.4.43]) by pivot.cnamts.fr (Netscape Messaging Server 3.5) with ESMTP id 262 for ; Wed, 12 Jun 2002 09:45:21 +0200 Received: from hermes1.cpam-cergypontoise.cnamts.fr ([127.0.0.1]) by hermes1.cpam-cergypontoise.cnamts.fr (Netscape Messaging Server 3.5) with SMTP id 773 for ; Wed, 12 Jun 2002 09:47:53 +0200 Message-ID: <003401c211e5$9a5f1220$3d04a837@PXXXX> From: "GRIMOIS Eric" To: Subject: General trigger function Date: Wed, 12 Jun 2002 09:48:55 +0200 Organization: CPAM du Val d'Oise MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200206/143 X-Sequence-Number: 8108 Hi all I read in the doc than a same function can be used for several triggers. I tried to create a function who updates a field with a timestamp and another field with the user name. This function is fired by triggers in several tables. It only works if updated fields have same names in all tables. I failed to create a function where fields names are parameters of the function. What's the way to do that ? Thanks. Eric GRIMOIS Analyste programmeur SEI - CPAM du Val d'Oise