PATCH: CITEXT 2.0 v3 - Mailing list pgsql-hackers

From David E. Wheeler
Subject PATCH: CITEXT 2.0 v3
Date
Msg-id 890EA230-DA04-4D65-996F-5E7107690BE8@kineticode.com
Whole thread Raw
Responses Re: PATCH: CITEXT 2.0 v3  ("David E. Wheeler" <david@kineticode.com>)
Re: PATCH: CITEXT 2.0 v3  (Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
List pgsql-hackers
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



Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.1 index corruption woes
Next
From: Alvaro Herrera
Date:
Subject: Re: 8.1 index corruption woes