On Jul 3, 2008, at 00:19, Teodor Sigaev wrote:

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);

Thanks. What would citext_hash() look like? I don't see a text_hash() to borrow from anywhere in src/.

Thanks,

David


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

Reply via email to