I would have never thought of that, great idea and greatly appreciated. I
assume that distinct understands the NULL state.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Sasha
Sent: Wednesday, July 11, 2007 7:41 AM
To: firebird-support@yahoogroups.com
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...

Sasha



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links