"Jimmy Choi" <[EMAIL PROTECTED]> writes: > I find that it doesn't work (i.e. index is not used and a sequential > scan is needed), if I have the following instead: > SELECT * FROM foo WHERE id = ANY (ARRAY[1,2]); > Is this expected?
Yes. That construct isn't indexable, period, in any existing release
(it does work in CVS tip though...)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
