Subject RE: [firebird-support] About EXISTS predicate
Author Vishal Tiwari
Hi Set....
It was nice to see you answering...
Thanks once again...
Have a Nice day....
Vishal Tiwari...

--- On Wed, 16/9/09, Svein Erling Tysvær <svein.erling.tysvaer@...> wrote:

From: Svein Erling Tysvær <svein.erling.tysvaer@...>
Subject: RE: [firebird-support] About EXISTS predicate
To: "" <>
Date: Wednesday, 16 September, 2009, 5:17 PM


>> Just one simple doubt, Is there any limitation for EXISTS predicate too, as
>> 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.

Moreover, as far as I know (may be wrong since I rarely use IN) the '1500 limitation' is only valid for statements like

IN (1, 2, 3, ..., 1499, 1500)

I'm pretty certain that you can use

IN (<subselect> )

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> )


From cricket scores to your friends. Try the Yahoo! India Homepage!

[Non-text portions of this message have been removed]