Re: [BUGS] BUG #4936: Bad result for SQL query

2009-07-23 Thread Tom Lane
"Mathieu Dupuis" writes: > Here are the result of the simplest query that recreate the problem, as you > can see the p.id and sod.performance_id are the same because I join on those > fields but if I compare with one, I have a different result that if I > compare the other. These queries are pret

[BUGS] BUG #4936: Bad result for SQL query

2009-07-23 Thread Mathieu Dupuis
The following bug has been logged online: Bug reference: 4936 Logged by: Mathieu Dupuis Email address: mdup...@premieresloges.ca PostgreSQL version: 8.4.0 Operating system: Ubuntu Description:Bad result for SQL query Details: I have found a probleme with a sql query