Postgres Pro
Downloads
Home   >   mailing lists

Re: The order of fields around the "=" in the WHERE conditions - Mailing list pgsql-performance

From Tom Lane
Subject Re: The order of fields around the "=" in the WHERE conditions
Date
Msg-id 16936.1144100107@sss.pgh.pa.us
Whole thread Raw
In response to The order of fields around the "=" in the WHERE conditions  ("Mike Quinn" <mquinn@co.merced.ca.us>)
List pgsql-performance
Tree view 
"Mike Quinn" <mquinn@co.merced.ca.us> writes:
> -- The order of fields around the "=" in the WHERE conditions
> -- affects the query plan.

That absolutely should not be happening.  Could we see a complete test
case?

            regards, tom lane

pgsql-performance by date:

Previous
From: "Mike Quinn"
Date:
Subject: The order of fields around the "=" in the WHERE conditions
Next
From: Tom Lane
Date:
Subject: Re: The order of fields around the "=" in the WHERE conditions