Re: Problems with Triggers - Mailing list pgsql-general

From Martin Marques
Subject Re: Problems with Triggers
Date
Msg-id 200404151158.27690.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Problems with Triggers  (Sebastian Böck <sebastianboeck@freenet.de>)
Responses Re: Problems with Triggers
List pgsql-general
El Jue 15 Abr 2004 08:55, Sebastian Böck escribió:
> 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

(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)

You forgot the parenthesis, to group the conditions accordingly

--
 11:56:01 up 37 days, 16:23,  2 users,  load average: 1.86, 0.99, 0.72
-----------------------------------------------------------------
Martín Marqués        | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica  |  DBA, Programador, Administrador
             Universidad Nacional
                  del Litoral
-----------------------------------------------------------------


pgsql-general by date:

Previous
From: "Thomas Chille"
Date:
Subject: PLpgSQL-Problem
Next
From: Sebastian Böck
Date:
Subject: Re: Problems with Triggers