RE: [GENERAL] non-case sensitive searches

From: Gregory Maxwell <greg(at)z(dot)ml(dot)org>
To: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
Cc: "Gene Selkov Jr(dot)" <selkovjr(at)mcs(dot)anl(dot)gov>, Kevin Heflin <kheflin(at)shreve(dot)net>, pgsql-general(at)postgreSQL(dot)org
Subject: RE: [GENERAL] non-case sensitive searches
Date: 1999-01-14 21:35:17
Message-ID: Pine.LNX.3.96.990114163410.13172A-100000@z.ml.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

  • Error at 1999-01-14 22:33:59 from Kaare Rasmussen

Browse pgsql-general by date

  From Date Subject
Next Message Kaare Rasmussen 1999-01-14 22:33:59 Error
Previous Message Jackson, DeJuan 1999-01-14 21:09:19 RE: [GENERAL] non-case sensitive searches