timestamps

[Tom Allison]

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?
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Larry Rosenman]

--On Tuesday, May 25, 2004 20:52:22 -0400 Tom Allison
<ta******@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: [phone] E-Mail: le*@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD8DBQFAs+92rRNGhTxJvdYRAlFSAKCPnutipCDWNVJY3I2IYu btsdkshQCfVFKG
x84g0s4UguwUQ3/ti1tzBGQ=
=sVW0
-----END PGP SIGNATURE-----

[Doug McNaught]

Tom Allison <ta******@tacocat.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

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Allison]

Doug McNaught wrote:

Tom Allison <ta******@tacocat.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.
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html