Re: PATCH: CITEXT 2.0

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: PATCH: CITEXT 2.0
Date: 2008-07-03 16:03:10
Message-ID: 4822F40A-617E-47CB-AD6E-0DDEAB25E15D@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-07-03 16:07:41 Re: A Windows x64 port of PostgreSQL
Previous Message Tom Lane 2008-07-03 16:01:25 Re: Resolving polymorphic functions with relateddatatypes