Re: PATCH: CITEXT 2.0

> Douglass book, though I probably missed it. Anyone got a link for me to 
> read to make it happen?

Hash opclass is 5-times simpler that btree one :)

CREATE FUNCTION citext_hash(mchar)
RETURNS int4
AS 'MODULE_PATHNAME'
LANGUAGE C IMMUTABLE RETURNS NULL ON NULL INPUT;

CREATE OPERATOR CLASS citext_ops
DEFAULT FOR TYPE mchar USING hash AS
               OPERATOR        1       =  (citext, citext),
               FUNCTION        1       citext_hash(citext);


-- 
Teodor Sigaev                                   E-mail: teodor@[EMAIL PROTECTED]
                                                    WWW:
http://www.sigaev.ru/

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers