"Mathieu Dupuis" <mdupuis@premieresloges.ca> 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 pretty much entirely useless without the table
definitions and sample data.
regards, tom lane