Zeljko Vrba [EMAIL PROTECTED] writes:
Is there yet another way of making WHERE field = ANY (subselect
returning an array) work? Or make postgres to use index?
You could use the int_array_enum() function from the contrib/int_agg module.
Also, what is the limit on the number of elements in
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi! I have posted this as a user comment in section 9.17:
-
= ANY(array expression) doesn't work in the obvious way when the array
expression is a subselect. For example:
select * from stat3 where stat3.id = any ('{4,5,6,7}');
works (and
Zeljko Vrba wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi! I have posted this as a user comment in section 9.17:
-
= ANY(array expression) doesn't work in the obvious way when the array
expression is a subselect. For example:
select * from stat3 where stat3.id = any