Обсуждение: NEW Used in Non-Rule Query

Поиск
Список
Период
Сортировка

NEW Used in Non-Rule Query

От
Raymond
Дата:
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