I need to know if a field was updated in an update statement, even if it was updated to the same value that it already contained.
Basically, I want the field to be automatically set to null if the update statement didn't manually set it to something. I could not figure out how to do this with a trigger or rules, as if the value was populated before the update statement, it will be in both the new and the old structures. My only thought is to have a trigger change the value that is updated and then if it is the same value in the new and the old then I know that it was not updated, but that is uglier then I would like. Any thoughts? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
