Re: [HACKERS] minor bug... - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] minor bug...
Date
Msg-id 38A33191.AE082DC8@alumni.caltech.edu
Whole thread Raw
In response to minor bug...  (Don Baccus <dhogaza@pacifier.com>)
List pgsql-hackers
> I assume not having a type added to hash ops isn't fatal, because
> "numeric" isn't there and Jan strikes me as being a very thorough
> guy...

A hash index is probably even less useful than the btree index for
this type, unless it can be used with multi-column indices. Because
the hash will chain duplicate values into a list of some kind, and
you'll get *long* lists.

Find and steal the code for "char" (the real one-byte character type).
But a one-bit hash is what you really want, so it may be better to
implement your own.
                 - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [HACKERS] make_ctags script
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] createdb default arguments