|Subject||RE: [firebird-support] About EXISTS predicate|
|Author||Svein Erling Tysvær|
>> Just one simple doubt, Is there any limitation for EXISTS predicate too, asMoreover, as far as I know (may be wrong since I rarely use IN) the '1500 limitation' is only valid for statements like
>> we have for IN predicate for 1500 values ?
>No, because EXISTS is a different construct than IN, which does not
>expect a list of input values.
IN (1, 2, 3, ..., 1499, 1500)
I'm pretty certain that you can use
without any limitation as to how many rows the subselect may return (well, at least the limit should be a lot higher than 1500).
Just wanted to clarify since your question a few days ago contained IN (<subselect>)