Actually, a default of now() would be perfectly providing you created a rule to
trap insert's and updates and remove the setting for that time/date from being
inserted so as to have the db use the dfault which I think is far easier that
making a silly trigger for something so simple.
Dan
Dave We
Dave,
Please look at the docs for creating triggers.
(http:/www.postgresql.org/docs/).
Hopefully, someone on this list with more experience with Update and
Insert triggers can give you some help in avoiding the classic problems,
such as infinite loops.
Let me ask the obvious question:
If the Ins
One person suggested setting now() as default.
That would work sometimes, but I have a situation where the user program is
updating the default field with 0. now() never gets into the field.
So, regardless of what the user enters, I want now() to be updated, and I
guess it would be via a trigge
