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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
