Slavomir Skopalik wrote:

>
>
>
>
> > There are many times that the database developer can't predict (it's
> > dependent on the user) an interval of records that your statement will act.
>
> > Example:
> > select * form t where id in (1, 5, ...)
> > or
> > select * from t where id between 5 and 10 or id between 20 and 30 or
> > id = 50
>
> Hi,
>
> I will be prefer only extended syntax for IN operator not new operator like:
>
> SELECT * FROM table WHERE id IN(0..3,4,6..9)
>

This continues to be a static statement, and not a dynamic one as I'm
proposing.


Adriano