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

From David E. Wheeler
Subject Re: PATCH: CITEXT 2.0 v3
Date
Msg-id 8709D06C-AAFE-4712-85B0-852964369BC8@kineticode.com
Whole thread Raw
In response to PATCH: CITEXT 2.0 v3  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: PATCH: CITEXT 2.0 v3  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CommitFest: how does handoff work for non-committer reviewers?
Next
From: Gregory Stark
Date:
Subject: Re: No answers on CommitFest procedures?