Skip site navigation (1) Skip section navigation (2)

PATCH: CITEXT 2.0 v3

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 (view raw or flat)
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: citext3.patch.gz
Description: application/x-gzip (19.2 KB)

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2008-07-08 01:17:17
Subject: Re: 8.1 index corruption woes
Previous:From: Tom LaneDate: 2008-07-08 00:39:47
Subject: Re: 8.1 index corruption woes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group