From 9e8da0f75731aaa7605cf4656c21ea09e84d2eb1 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 16 Oct 2011 15:39:24 -0400 Subject: Teach btree to handle ScalarArrayOpExpr quals natively. This allows "indexedcol op ANY(ARRAY[...])" conditions to be used in plain indexscans, and particularly in index-only scans. --- src/backend/utils/adt/selfuncs.c | 7 ------- 1 file changed, 7 deletions(-) (limited to 'src/backend/utils/adt/selfuncs.c') diff --git a/src/backend/utils/adt/selfuncs.c b/src/backend/utils/adt/selfuncs.c index 8ceea820bdc..96946281dab 100644 --- a/src/backend/utils/adt/selfuncs.c +++ b/src/backend/utils/adt/selfuncs.c @@ -6385,14 +6385,7 @@ btcostestimate(PG_FUNCTION_ARGS) * is that multiple columns dilute the importance of the first column's * ordering, but don't negate it entirely. Before 8.0 we divided the * correlation by the number of columns, but that seems too strong.) - * - * We can skip all this if we found a ScalarArrayOpExpr, because then the - * call must be for a bitmap index scan, and the caller isn't going to - * care what the index correlation is. */ - if (found_saop) - PG_RETURN_VOID(); - MemSet(&vardata, 0, sizeof(vardata)); if (index->indexkeys[0] != 0) -- cgit v1.2.3