Re: on update set default

On 2001-12-09 "Ben-Nes Michael" <miki@canaan.co.il> wrote:
>Im want that on each insert, update to a table the column:
>changed_on TIMESTAMP DEFAULT now()
>will be set to now();

In the PostgreSQL 7.1 Programmer's guide

http://www.postgresql.org/idocs/index.php?plpgsql-trigger.html

I guess it's more than you need.

--
AXXESSIT ASA                  http://www.axxessit.no
Rolf Østvik / Test technician