Skip site navigation (1) Skip section navigation (2)

Re: BUG #4936: Bad result for SQL query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mathieu Dupuis" <mdupuis(at)premieresloges(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4936: Bad result for SQL query
Date: 2009-07-23 16:22:22
Message-ID: 18160.1248366142@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Mathieu Dupuis" <mdupuis(at)premieresloges(dot)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

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-07-23 17:43:40
Subject: Re: BUG #4934: regression in IN with joins in subselect
Previous:From: Mathieu DupuisDate: 2009-07-23 15:45:01
Subject: BUG #4936: Bad result for SQL query

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group