> 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%').