Re: on update set default

From: Doug McNaught <doug(at)wireboard(dot)com>
To: "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: on update set default
Date: 2001-12-09 15:53:38
Message-ID: m31yi475kt.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> writes:

> 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 :(

An AFTER trigger to do this should be pretty easy. Why don't you post
what you've tried and we'll see where you went wrong?

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2001-12-09 17:24:52 Questions about the upcoming 7.2?
Previous Message Ben-Nes Michael 2001-12-09 13:50:10 on update set default