Subject Re: [firebird-support] FB 2.0: column = NULL
Author Paul Vinkenoog
Dmitry Yemanov wrote:

>>> I know there is a new feature in fb 2.0 which makes expressions like
>>> column =3D NULL
>>> valid!

>> It's not really a feature. It's a syntax relaxation, and as a rule
>> you shouldn't use it. It just gives you more rope to hang yourself.

> There's also a feature: IS [NOT] DISTINCT FROM predicate.

And a very welcome one. The only thing I don't like is that it's so
long, especially for such a basic test. I would love to be able to use
IS [NOT] as a shorthand alias. It would fit the existing IS [NOT] NULL
syntax seamlessly. Hmm, maybe I'll enter this in the tracker as a
feature request.


Greetings,
Paul Vinkenoog