Hi,

> just to queries like this:
>
> select p.name from phones p where p.extension in
> (0000, 0001, 0002, 0003, 0004, 0005, 0006, 0007,.... 1499)
>
> The restriction may be lifted in V2, I don't remember.

No, it isn't changed.

btw as workaround you can split the IN part in multiple IN predicates combined by the OR operator.

select p.name from phones p where
p.extension IN (0000, 0001, 0002, 0003, ...1499) OR
p.extension IN (1500, 1501, 1502, 1503, ...2999) ...

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info