CIText and pattern_ops - Mailing list pgsql-hackers

From Rod Taylor
Subject CIText and pattern_ops
Date
Msg-id y2j751261b21004232027xc1979803mc20b2bcd688912c2@mail.gmail.com
Whole thread Raw
Responses Re: CIText and pattern_ops  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
Re: CIText and pattern_ops  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Is there any particular reason why the citext module doesn't have
citext_pattern_ops operator family?

Specifically, I wish to index for this type of query:

... WHERE citext_column LIKE 'Foo%';

This, of course, is equivalent to ILIKE 'Foo%' which does not appear
to be indexable without using a functional index (
lower(citext_column) ).


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: global temporary tables
Next
From: Robert Haas
Date:
Subject: Re: global temporary tables