NEW Used in Non-Rule Query

From: Raymond <support(at)bigriverinfotech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: NEW Used in Non-Rule Query
Date: 2003-07-21 13:36:20
Message-ID: 200307210636.20155.support@bigriverinfotech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message u15074 2003-07-21 13:57:50 Re: Checkpoint question
Previous Message Ron Johnson 2003-07-21 13:01:50 Re: database design of products catalogue