Joseph Healy <[EMAIL PROTECTED]> writes: > On Sat, Sep 25, 2004 at 07:20:23PM -0400, Tom Allison wrote: >> >> Any idea how to set up a timestamp=now on every insert/update ? > > when you create your table, use: > > create table mytable ( > id serial primary key, > updated timestamp default(now()), > mydata int4 > );
That won't change the timestamp on UPDATE queries; you need a trigger for that. -Doug -- Let us cross over the river, and rest under the shade of the trees. --T. J. Jackson, 1863 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
