RE: [GENERAL] non-case sensitive searches - Mailing list pgsql-general

On Wed, 13 Jan 1999, Jackson, DeJuan wrote:

> And remember unless you use full text indexing (which is expensive) you
> won't have indexing on that search (for either the LIKE or regex).
>     -DEJ

Actually, if you use case sensitive regex, and anchor the begining (with
^) then it will use btree indexes.