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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <pgsql-performance@xxxxxxxxxxxxxx>
Subject: Re: The order of fields around the "=" in the WHERE
From: "Mike Quinn" <mquinn@xxxxxxxxxxxxxxx>
Date: Tue, 04 Apr 2006 10:18:30 -0700
In-reply-to: <17162.1144101482@xxxxxxxxxxxxx>
References: <44313030020000E5000001DA@xxxxxxxxxxxxxxxxxxxxxxx><44313030020000E5000001DA@xxxxxxxxxxxxxxxxxxxxxxx> <17162.1144101482@xxxxxxxxxxxxx>

The datatype of the join columns is a user defined type and there are no
commutators defined. I will fix that and retest. Thanks for the
insight.

Mike Quinn

Follow-Ups:
- Re: The order of fields around the "=" in the WHERE
  - From: Mike Quinn

References:
- The order of fields around the "=" in the WHERE conditions
  - From: Mike Quinn
- Re: The order of fields around the "=" in the WHERE conditions
  - From: Tom Lane

Prev by Date: Re: vacuum full seems to hang on very small table
Next by Date: Query runs too long for indexed tables
Previous by thread: Re: The order of fields around the "=" in the WHERE conditions
Next by thread: Re: The order of fields around the "=" in the WHERE
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux