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

From Gregory Maxwell
Subject RE: [GENERAL] non-case sensitive searches
Date
Msg-id Pine.LNX.3.96.990114163410.13172A-100000@z.ml.org
Whole thread Raw
In response to RE: [GENERAL] non-case sensitive searches  ("Jackson, DeJuan" <djackson@cpsgroup.com>)
Responses Error  (Kaare Rasmussen <kar@webline.dk>)
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.



pgsql-general by date:

Previous
From: "Sergei M. Suntsov"
Date:
Subject: Re: [GENERAL] 'Pg' is what we called DBI?
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] non-case sensitive searches