I found that following query works:
create temp table test ( test int ) on commit drop;
insert into test values(1);
select * from test where test = ANY ( '{1,2}' );
Is this best solution ?
Will it work without causing stack overflow with 8.2 server default
settings
if string contains some thousands numbers ?
I have found that IN (1,2,...) causes stack overflow in server if there are
large number of items in list.
Andrus.
