Re: Trigger performance

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: Mon, 20 Sep 1999 22:05:00 GMT
Message-ID: <37e6af60.213830474@news.globalnet.co.uk>

On Sun, 19 Sep 1999 15:45:51 +0100, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>
>You do have to be a little careful with IN lists.
>Remember that a check constraint is true
>if it is not false - i.e. a test that evaluates to
>NULL has not evaluated to false and therefore
>is deemed to be true.
>
>In this case you may want to include an
>is/is not null test on action_type, or have
>a NOT NULL constraint on action_type.
>

Mea culpa - I was assuming that action type is not null which I would expect to be the usual case. Received on Mon Sep 20 1999 - 17:05:00 CDT