Received: from gabuzo.meunet (IDENT:postfix@d004.paris-132.cybercable.fr [212.198.132.4]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA05409 for ; Sun, 31 Oct 1999 14:52:40 -0500 (EST) (envelope-from christophe.labouisse@dial.oleane.com) Received: by gabuzo.meunet (Postfix, from userid 501) id 69B06173F0; Sun, 31 Oct 1999 20:52:38 +0100 (CET) Sender: moi@localhost.localdomain To: pgsql-sql@postgreSQL.org, Tulassay Zsolt Subject: Re: [SQL] auto datetime update on UPDATE? References: Reply-To: christophe.labouisse@dial.oleane.com Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit From: Christophe Labouisse Date: 31 Oct 1999 20:52:38 +0100 In-Reply-To: Tulassay Zsolt's message of "Sun, 31 Oct 1999 16:54:50 +0100 (CET)" Message-ID: Lines: 42 X-Mailer: Gnus v5.6.45/XEmacs 21.1 - "Biscayne" Tulassay Zsolt writes: > Hi, > > i have set up a table, where two fields (creation_dt and modification_dt) > always get the actual date/time by default when doing an INSERT. > my question is, how is it possible to let the field modification_dt > change when doing an UPDATE? > Is there a way to solve it in SQL? To do this I use a trigger in plpgsql : create function liens_maj_fun () returns opaque as ' begin new.liens_maj := ''now''; return new; end; ' language 'plpgsql'; create trigger liens_maj_trig before update or insert on liens for each row execute procedure liens_maj_fun(); Since it uses plpgsql don't forget to add it when you create your base: CREATE FUNCTION plpgsql_call_handler() RETURNS opaque AS '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'c'; CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'; -- christophe.labouisse@dial.oleane.com Le cinéma en Lumière : http://www.lumiere.org/ Vote en cours pour la création du forum fr.rec.arts.sf.starwars pour en savoir plus :