Skip site navigation (1) Skip section navigation (2)

Re: timestamps

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Tom Allison <tallison(at)tacocat(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: timestamps
Date: 2004-05-26 01:14:30
Message-ID: E161D7D12B64C04F928E2E6C@lerlaptop.lerctr.org (view raw or flat)
Thread:
Lists: pgsql-general

--On Tuesday, May 25, 2004 20:52:22 -0400 Tom Allison 
<tallison(at)tacocat(dot)net> wrote:

> How would I specify a field that's to be updated to current_time
> everytime the row is created/altered?
>
> Is there some way to put this 'update' property into the table instead of
> running some query to do it?
You are looking for a trigger.


>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

  • timestamps at 2004-05-26 00:52:22 from Tom Allison

pgsql-general by date

Next:From: Tom AllisonDate: 2004-05-26 01:31:11
Subject: Re: timestamps
Previous:From: Doug McNaughtDate: 2004-05-26 01:10:26
Subject: Re: timestamps

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group