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

From Jan Wieck
Subject Re: int8 primary keys still not using index without manual
Date
Msg-id 3FAD44EA.3060601@Yahoo.com
Whole thread Raw
In response to Re: int8 primary keys still not using index without manual  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: int8 primary keys still not using index without manual  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:

> 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.

I like that approach even better than mine. It needs less work during
the actual planning.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: Holger Marzen
Date:
Subject: Re: Power Electrical Down!!!!!
Next
From: Alvaro Herrera
Date:
Subject: Re: Referencing columns from system tables possible?