On Wed, 10 Jul 2002, Tom Lane wrote: > Bradley Baetz <[EMAIL PROTECTED]> writes: > > I'm referring to the mysql |timestamp| type, which will update that > > column's contents to |now()| when any UPDATE is given for that partcular > > row, unless the column was assigned to. I don't know how to handle the > > last part in a trigger. > > It'd probably be close enough to have an UPDATE trigger that does > > if (new.timestamp = old.timestamp) > new.timestamp = now();
Nope, because the documented way of making sure that the field doens't change is to use |UPDATE foo SET bar=bar ....|, and thats what bz uses. Don't worry about this, though - we will hpefully be removing this 'feature' soon. Bradley ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
