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.
In response to
- timestamps at 2004-05-26 00:52:22 from Tom Allison
pgsql-general by date
|Next:||From: Larry Rosenman||Date: 2004-05-26 01:14:30|
|Subject: Re: timestamps|
|Previous:||From: Tom Allison||Date: 2004-05-26 00:52:22|