Re: BUG #4290: wrong double subselect with aggregate function - Mailing list pgsql-bugs

Andreas wrote:

>  min_c_id | b_aid | min_c_id_1 | min_c_id_2
> ----------+-------+------------+------------
>         1 |     1 |          1 |          3
>         1 |     2 |          1 |          3
>
> I expected for min_c_id in the second row 3.

Which it is if you turn enable_indexscan to off ...

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.