Adriano dos Santos Fernandes wrote:

>
> Hence, a way to pass indeterminate number of intervals is very great:
> select * from t where id in list '5-10,20-30,50'

Do we speak about lists or ranges or both? IMO, the syntax should be
clear about that.

> And I see this syntax as a complement to FB2.1 LIST aggregate function,
> i.e. result of LIST can be passed to IN LIST. Example:
> select list(id) from t into :ids;
> for select * from t where id in list :ids ...

1) What will be a complement for:
select list(id, '$') from t into :ids
?

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?


Dmitry