> I don't get it, > you mean even if the field contain some data, it would be set to null > if your update statement do not update the field? Exactly. In my example, I have a record that shows current status and can be updated by multiple processes. The only thing that is relevant when I look at it is the last update. If process 1 updates fields A, B and C and process 2 only updates fields A and B, then I want to set C to null so that when I look at the current status, I see what the last status that was set is. I also don't have the ability to change all the other processes, so that they set fields that they are not using to null. In MSSQL triggers there is an UPDATE function that tells you if this column was set in the update statement. I am looking for similar functionality. Sim -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
