Re: int8 primary keys still not using index without manual - Mailing list pgsql-general

From Tom Lane
Subject Re: int8 primary keys still not using index without manual
Date
Msg-id 12635.1068313743@sss.pgh.pa.us
Whole thread Raw
In response to Re: int8 primary keys still not using index without manual  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: int8 primary keys still not using index without manual
List pgsql-general
Jan Wieck <JanWieck@Yahoo.com> writes:
> Tom Lane wrote:
>> Th big picture is that it doesn't work very well to assume that indexes
>> only need to handle same-datatype comparisons.  I think we are
>> ultimately going to have to address that issue more-or-less directly.

> Wouldn't that logically lead to an "abstract" operator class to be
> pointed to in the original indexes operator class?

I've just posted a proposal in pgsql-hackers that attacks the problem
a little differently: put the cross-type operators directly into the
opclass.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL, Postgre and Apple
Next
From: Rajesh Kumar Mallah
Date:
Subject: Converting SQL-ASCII encoding database to UNICODE