Kenneth Marshall <ktm(at)rice(dot)edu> writes:
> On Mon, Jun 21, 2010 at 03:36:07PM -0400, Tom Lane wrote:
>> You might consider creating an index on lower(full_name) and then
>> querying WHERE lower(full_name) LIKE whatever.
> Would citext support this?
No, unfortunately. The index optimization for LIKE is hard-wired into
the planner, so it only supports built-in data types. Someday it'd be
nice to have a way for add-on modules to insert that sort of
optimization.
regards, tom lane