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.
