<gn*****@rcn.com> wrote in message
news:11*********************@c13g2000cwb.googlegro ups.com...
i can't find either confirmation or contradiction in the docs
available. a colleague asserts that a column defined TIMESTAMP
is always and automatically updated when any column in the row
is changed; no triggers or application code needed. is he
smoking something he shouldn't be?
If the column is defined as "NOT NULL WITH DEFAULT" then an insert statement
that does not supply a value for the column will default to the current
timestamp. The value will not change on an UPDATE unless the statement uses
either "current timestamp" or "default" as the value in the SET clause.
So in answer to your question, yes, your friend is smoking something.