Joseph Healy <joe_healy(at)dodo(dot)com(dot)au> 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