Problems with Triggers

From: Sebastian Böck <sebastianboeck(at)freenet(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems with Triggers
Date: 2004-04-15 11:55:22
Message-ID: 407E782A.7070909@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Williams 2004-04-15 13:00:03 Re: upgrading postgresql from 7.2 to 7.3, getting error
Previous Message Roberto Amorim 2004-04-15 11:55:06 How to unsobscreve from this list?