Re: Planner regression in 9.1: min(x) cannot use partial index with NOT NULL

On Tue, Mar 22, 2011 at 4:35 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Reimplement planner's handling of MIN/MAX aggregate optimization (again).
>

I'm just curious, Why is this no longer an interesting special case?


--- this is an interesting special case as of 9.1
-explain (costs off)
-  select min(unique2) from tenk1 where unique2 = 42;
-                  QUERY PLAN
------------------------------------------------
- Aggregate
-   ->  Index Scan using tenk1_unique2 on tenk1
-         Index Cond: (unique2 = 42)



-- 
greg