on update set default

From: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
To: <pgsql-general(at)postgresql(dot)org>
Subject: on update set default
Date: 2001-12-09 13:50:10
Message-ID: 002a01c180b8$6b774180$aa0f5ac2@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All

Im want that on each insert, update to a table the column:
changed_on TIMESTAMP DEFAULT now()
will be set to now();

any one can hint me ?
I tried few rulles and triggers for hours with no luck :(

--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-12-09 15:53:38 Re: on update set default
Previous Message Tommi Mäkitalo 2001-12-09 09:32:11 Re: Database permissions