Re: The order of fields around the "=" in the WHERE conditions

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Mike Quinn" <mquinn(at)co(dot)merced(dot)ca(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: The order of fields around the "=" in the WHERE conditions
Date: 2006-04-03 21:35:07
Message-ID: 16936.1144100107@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Mike Quinn" <mquinn(at)co(dot)merced(dot)ca(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-04-03 21:58:02 Re: The order of fields around the "=" in the WHERE conditions
Previous Message Mike Quinn 2006-04-03 21:24:48 The order of fields around the "=" in the WHERE conditions