Subject RE: [firebird-support] Re: multiple inserts in trigger
Author Ross Ryding
I would have never thought of that, great idea and greatly appreciated. I
assume that distinct understands the NULL state.

-----Original Message-----
[] On Behalf Of Sasha
Sent: Wednesday, July 11, 2007 7:41 AM
Subject: RE: [firebird-support] Re: multiple inserts in trigger

> Firdt idea: NULL's usually need to be handled separately because
> nothing equals NULL, not even NULL. You may only check for NULL using
> the "is null" operator.

Another option for testing null values is to use distinct as in if (value1
is distinct from value2) then...
It's only syntactic sugar as they say but it does save a couple of lines...



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links