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: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
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> )

Set
















From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew

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