Re: About UPDATE triggers...

In article <5mn7mr$lrk@cssun.mathcs.emory.edu>, MMASHALK@ccsmtp.farinon. harris.com writes > Hi , > > I am posting this question for a friend. > > There's the question : > > In Informix triggers (Update Trigger on a table for all columns > [default]), is there a way of finding out which columns are > getting updated ? > > In Oracle, you can do IF UPDATING (column_name). You can check > by comparing pre.column_name with post.column_name. But if a > column is being updated with the old value it self then this > would not be useful. > > Do you have any idea/clues/suggestions ? I don't think you can do it but then next question is, Why does an update of a column to the same value matter? > > > TIA > > Max -- David Williams