Re: timestamps

--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