Tom Lane <tgl@sss.pgh.pa.us> writes:
> Works fine for me, eg
...
> -> Bitmap Heap Scan on tenk1 b (cost=0.79..4.82 rows=3 width=244)
> Recheck Cond: (b.unique2 = ANY (ARRAY[a.unique1, a.ten, a.hundred]))
> -> Bitmap Index Scan on tenk1_unique2 (cost=0.00..0.79 rows=3 width=0
> )
> Index Cond: (b.unique2 = ANY (ARRAY[a.unique1, a.ten, a.hundred])
But that's an index on the lhs of the =ANY which in his example was just a
constant.
> You'll need to provide a concrete test case if you think there's
> something broken here.
I think he's looking for something like:
5 IN (col1,col2,col3)
resulting in a bitmap or of three index scans of three different indexes on
col1, col2, and col3.
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!