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
Responses
pgsql-hackers by date
| Next: | From: Alvaro Herrera | Date: 2008-07-08 01:17:17 |
| Subject: Re: 8.1 index corruption woes |
| Previous: | From: Tom Lane | Date: 2008-07-08 00:39:47 |
| Subject: Re: 8.1 index corruption woes |