Subject | Re: [firebird-support] Table Scans and != |
---|---|
Author | Paul Vinkenoog |
Post date | 2003-08-05T01:01:57Z |
Hi Daniel,
BTW, IB/FB also recognize ^= (in C this means: lhs = lhs xor rhs) and
~= for "not equal". Pick and choose...
Grtz,
Paul
>>> In fact, what does != signify? Not equal?Thanks for the info. <> indeed 'fits better' in SQL.
>
>> Yes, !- means the same in C as <> in Pascal. Both are recognized by
>> IB/FB. Kind of weird, actually. (I wonder if both are standard SQL?)
>
> Actually the not equal operator in the SQL standard is <>.
BTW, IB/FB also recognize ^= (in C this means: lhs = lhs xor rhs) and
~= for "not equal". Pick and choose...
Grtz,
Paul