Re: PATCH: CITEXT 2.0 v3

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: David E(dot) Wheeler <david(at)kineticode(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PATCH: CITEXT 2.0 v3
Date: 2008-07-09 20:28:35
Message-ID: 8709D06C-AAFE-4712-85B0-852964369BC8@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I guess you're all just blown away by the perfection of this patch? ;-)

Best,

David

On Jul 7, 2008, at 18:03, David E. Wheeler wrote:

> Attached is a new version of a patch to add a CITEXT contrib module.
> Changes since v2:
>
> * Optimized citext_eq() and citext_ne() (the = and <> operators,
> respectively) by having them use strncmp() instead of varstr_cmp().
> Per discussion.
>
> * Added `RESTRICT` and `JOIN` clauses to the comparison operators
> (=, <>, <, >, <=, >=). These improve statistics estimations,
> increasing the liklihood that indices will be used.
>
> Thanks!
>
> David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2008-07-09 20:30:13 Re: No answers on CommitFest procedures?
Previous Message Tom Lane 2008-07-09 19:14:05 Re: CommitFest: how does handoff work for non-committer reviewers?