NEW Used in Non-Rule Query
Started by Raymondover 22 years ago1 messagesgeneral
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