Re: timestamps - Mailing list pgsql-general

From Larry Rosenman
Subject Re: timestamps
Date
Msg-id E161D7D12B64C04F928E2E6C@lerlaptop.lerctr.org
Whole thread Raw
In response to timestamps  (Tom Allison <tallison@tacocat.net>)
List pgsql-general

--On Tuesday, May 25, 2004 20:52:22 -0400 Tom Allison
<tallison@tacocat.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Attachment

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: timestamps
Next
From: Tom Allison
Date:
Subject: Re: timestamps