Jim Starkey wrote:

> Language extensions make sense to express something that couldn't
> otherwise be expressed or to express something in a form that will
> result in better performance. So far, I don't think you've met the test.
>> But just think... This is a case use of well written applications that
>> allows the user to filter things based on his need.
>>
> Sorry, I'm not yet convinced.

Me neither.
I can't see how you provide the user with the tools to make these random
selections in the first place. I end up with a temporary table holding a
set of temporary flags to the data in question and check the filters are
at least valid. And I then use that as the SELECT for an IN clause. The
client app can then modify the contents of the temporary table as they
require and simply retry with different selections.

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php