Re: Touch row ?

On Fri, 2004-01-23 at 16:52, Chris Boget wrote:
> > > is it possible to add column to database, that will automatically
> > > contain  date+time (or likely Unix timestamp) when the row was
> > > touched/changed - ie by INSERT or UPDATE ?
> > Yes, a very simple trigger can do this.
>
> Wouldn't just setting the default value of the field to be NOW() accomplish
> the same thing?  Or can you not default the value of a timestamp field?

No, that would only set the timestamp on INSERT, but not on any UPDATE.
The OP wanted to timestamp all updates too.

Cheers,
Csaba.

>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster