Re: [BUGS] BUG #7593: Unexpected query result combining or and in operators

2012-10-10 Thread Tom Lane
demur...@ockham-solutions.fr writes: > After a little while (probably after the analyze), the query plan is changed > and only 2 results are returned ! > "Merge Join (cost=33.31..39.69 rows=1 width=24)" > " Merge Cond: (i.numero_id = n.numero_id)" > ... > " -> Index Only Scan using numero_pkey

[BUGS] BUG #7593: Unexpected query result combining or and in operators

2012-10-10 Thread demurcia
The following bug has been logged on the website: Bug reference: 7593 Logged by: DE MURCIA Julien Email address: demur...@ockham-solutions.fr PostgreSQL version: 9.2.1 Operating system: Windows 7 Description: Hello, I am trying to run this query: select n.numero_id,