--- In Firebird-Architect@yahoogroups.com, Adriano dos Santos
Fernandes <adrianosf@...> wrote:

Perhaps I am missing the point you are trying to make, but I have two
comments:

1. Your concept of LIST seems to resemble Oracle collections. Like
with Oracle collections, if you have a variable of type LIST, why
would you need additional syntax in the DML?

2. Wouldn't your purposes be already served with the GTT feature we
already have?

create temporary table ids(i integer);

insert into ids (select val from ...); // or whatever other code to
fill ids programmatically

select * from mytable where idx in (select * from ids);

In summary, in my view we should look at implementing the concept of
collections in PSQL (of which GTT's are a form) and not look at a
specific, limited form of it.

Paul