a trigger for time

From: Luca Ferrari <fluca1978(at)virgilio(dot)it>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: a trigger for time
Date: 2003-11-25 17:01:44
Message-ID: 200311251801.44778.fluca1978@virgilio.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello to everyone,
I've got a set of tables where I need to store both the inserting and updating
time of a tuple. These columns are of coure two "time" columns. I'd like to
build a trigger (before) so that the time can be set up rightly when my
programs perform an insert or an update, but I cannot understand how to do
it. Does anybody know where I can find some example (or better is there
anybody who can send me an example)?

Thanks,
Luca

--
Luca Ferrari,
fluca1978(at)virgilio(dot)it

Browse pgsql-novice by date

  From Date Subject
Next Message Roy MacGregor Paterson 2003-11-25 20:21:54 Re: Failed to create a function
Previous Message Stephan Szabo 2003-11-25 16:43:56 Re: Failed to create a function