>> No. I need to support 8.0.
>> After those crashes I changed all IN clauses to
>> docid = ANY ({1,2,3,4,5,7,8,96,5445,.., 34534534})
>
> I'm afraid that hardly counts as "supporting" 8.0 (or 8.1 for that
> matter). The syntax may work but it can't be indexed.
I'm sorry. It seems that Richard Huxton suggestion in this mailing list
SELECT * FROM generate_series(1,10) s
WHERE s = ANY (string_to_array('1,3,5,7', ',')::int[]);
works in 8.0
I hope that this works as well as new array syntax.
Andrus.
