NEW Used in Non-Rule Query - Mailing list pgsql-general

From Raymond
Subject NEW Used in Non-Rule Query
Date
Msg-id 200307210636.20155.support@bigriverinfotech.com
Whole thread Raw
List pgsql-general
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




pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: database design of products catalogue
Next
From: u15074
Date:
Subject: Re: Checkpoint question