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.