| From: | "David E(dot) Wheeler" <david(at)kineticode(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | PATCH: CITEXT 2.0 v3 |
| Date: | 2008-07-08 01:03:56 |
| Message-ID: | 890EA230-DA04-4D65-996F-5E7107690BE8@kineticode.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Content-Type | Size |
|---|---|---|
| citext3.patch.gz | application/x-gzip | 19.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2008-07-08 01:17:17 | Re: 8.1 index corruption woes |
| Previous Message | Tom Lane | 2008-07-08 00:39:47 | Re: 8.1 index corruption woes |