Subject Re: [Firebird-Architect] IN LIST
Author Dmitry Yemanov
Adriano dos Santos Fernandes wrote:
>
>> 2) Why is it better than a simple:
>>
>> for
>> select * from t
>> where id in ( select ... )
>> ?
>>
>> I.e. why would you need an intermediate step?
>
> This requires inserting in a temp table and don't work for ranges.

1) The LIST aggregate function doesn't return ranges anyway.
2) Why a temp table requirement?

My question was not about IN LIST usage in general, I just question the
point of it being considered a complement for the LIST function.


Dmitry