Re: PATCH: CITEXT 2.0 - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: PATCH: CITEXT 2.0
Date
Msg-id 4822F40A-617E-47CB-AD6E-0DDEAB25E15D@kineticode.com
Whole thread Raw
In response to Re: PATCH: CITEXT 2.0  (Teodor Sigaev <teodor@sigaev.ru>)
Responses Re: PATCH: CITEXT 2.0  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Resolving polymorphic functions with relateddatatypes
Next
From: Tom Lane
Date:
Subject: Re: A Windows x64 port of PostgreSQL