Обсуждение: Trigger: Column Update
Hi, I am wondering if there is a way to identify which columns have been modified. Is there some sort of TG_TABLE_NAME, which states the modified columns ? Or should we check this ourselves doing something like OLD.columnA != NEW.columnA ? Regards Ricardo
Le 12/11/2010 18:37, Ricardo Bayley a écrit : > Hi, > > I am wondering if there is a way to identify which columns have been > modified. Is there some sort of TG_TABLE_NAME, which states the > modified columns ? Nope. You should check yourself. > Or should we check this ourselves doing something like OLD.columnA != > NEW.columnA ? Use IS DISTINCT OF instead of = to deal with NULL values. -- Guillaume http://www.postgresql.fr http://dalibo.com
Will do that then Thanks Guillaume 2010/11/12 Guillaume Lelarge <guillaume@lelarge.info>: > Le 12/11/2010 18:37, Ricardo Bayley a écrit : >> Hi, >> >> I am wondering if there is a way to identify which columns have been >> modified. Is there some sort of TG_TABLE_NAME, which states the >> modified columns ? > > Nope. You should check yourself. > >> Or should we check this ourselves doing something like OLD.columnA != >> NEW.columnA ? > > Use IS DISTINCT OF instead of = to deal with NULL values. > > > -- > Guillaume > http://www.postgresql.fr > http://dalibo.com >