Re: BUG #4936: Bad result for SQL query - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4936: Bad result for SQL query
Date
Msg-id 18160.1248366142@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4936: Bad result for SQL query  ("Mathieu Dupuis" <mdupuis@premieresloges.ca>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: "Mathieu Dupuis"
Date:
Subject: BUG #4936: Bad result for SQL query
Next
From: Tom Lane
Date:
Subject: Re: BUG #4934: regression in IN with joins in subselect