Receive the following error in PL/pgSQL
"Error: New Used in Non-Rule Query"
when attempting a comparison of NEW and OLD records in an update block:
IF TG_OP = ''UPDATE'' THEN
IF NEW != OLD THEN
...
...
END IF;
END IF;
How does one compare records for change in PL/pgSQL without resorting to a
attribute-by-attribute comparison?
Raymond
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
