Subject | Re: [Firebird-Architect] IN LIST |
---|---|
Author | Dmitry Yemanov |
Post date | 2006-12-03T13:55:10Z |
Adriano dos Santos Fernandes wrote:
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
>1) The LIST aggregate function doesn't return ranges anyway.
>> 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.
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