Problems with Triggers - Mailing list pgsql-general

From Sebastian Böck
Subject Problems with Triggers
Date
Msg-id 407E782A.7070909@freenet.de
Whole thread Raw
Responses Re: Problems with Triggers
Re: Problems with Triggers
List pgsql-general
Hello,

is there a simple operator to determine whether the OLD.value and
NEW.value are different. The <> operator is not working on NULL's.

I need something like this:
NEW.val <> Old.val OR
NEW.val IS NULL AND OLD.val IS NOT NULL OR
NEW.val IS NOT NULL AND OLD.val IS NULL

Thanks in advance

Sebastian

pgsql-general by date:

Previous
From: Alan Graham
Date:
Subject: Anyone using pgreplicator?
Next
From: "Thomas Chille"
Date:
Subject: PLpgSQL-Problem