Re: timestamps

From: Tom Allison <tallison(at)tacocat(dot)net>
To: Doug McNaught <doug(at)mcnaught(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: timestamps
Date: 2004-05-26 01:31:11
Message-ID: 40B3F35F.5060006@tacocat.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug McNaught wrote:
> Tom Allison <tallison(at)tacocat(dot)net> writes:
>
>
>>How would I specify a field that's to be updated to current_time
>>everytime the row is created/altered?
>
>
> Create a trigger. There are some good examples in the PL/pgSQL docs.
>
>
>>Is there some way to put this 'update' property into the table instead
>>of running some query to do it?
>
>
> Triggers are the way to go in Postgres.
>
> -Doug
>

Thanks for the pointer. That should be enough.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wei Shi 2004-05-26 01:46:03 Re: About table schema
Previous Message Larry Rosenman 2004-05-26 01:14:30 Re: timestamps