Tom Allison <tallison@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
