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