Re: serial data type

Doug McNaught wrote:
> 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.

Thanks!
Understood.

I'll get to that tomorrow.  Right now I'm working on data types and
tables....