Re: Why hash indexes suck - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Why hash indexes suck
Date
Msg-id 1086474634.13110.199.camel@jeff
Whole thread Raw
In response to Re: Why hash indexes suck  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Why hash indexes suck
List pgsql-hackers
On Sat, 2004-06-05 at 13:31, Tom Lane wrote:
> Only if you want to require a hash opclass to supply ordering operators,
> which sort of defeats the purpose I think.  Hash is only supposed to
> need equality not ordering.

Is it possible to assume some kind of ordering (i.e. strcmp() the binary
data of the type) as long as it's consistent?

Regards,Jeff



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Official Freeze Date for 7.5: July 1st, 2004
Next
From: Tom Lane
Date:
Subject: Re: Why hash indexes suck