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

From Jackson, DeJuan
Subject RE: [GENERAL] non-case sensitive searches
Date
Msg-id F10BB1FAF801D111829B0060971D839F5E1B68@cpsmail
Whole thread Raw
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.

So will a front anchored LIKE, but the query that was being performed
was an unanchored LIKE (i.e. '%stuff%').

pgsql-general by date:

Previous
From: Gregory Maxwell
Date:
Subject: RE: [GENERAL] non-case sensitive searches
Next
From: Kaare Rasmussen
Date:
Subject: Error