Doug McNaught wrote:
> 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.
Thanks!
Understood.
I'll get to that tomorrow. Right now I'm working on data types and
tables....