Re: serial data type

Joseph Healy <joe_healy@dodo.com.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