| Subject | Re: [firebird-support] Problem with not in queries in Firebird 2.0 RC3 |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2006-07-05T05:40:34Z |
"Graeme Edwards" <g.edwards@...> wrote:
Only for NOT NULL columns being a subject of NOT IN predicate. If the column
is nullable, then NOT EXISTS and NOT IN are not equivalent and expected to
return different results.
Dmitry
>indices?
> Is NOT EXISTS also an option to replace NOT IN in that it will use
Only for NOT NULL columns being a subject of NOT IN predicate. If the column
is nullable, then NOT EXISTS and NOT IN are not equivalent and expected to
return different results.
Dmitry