| From: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
|---|---|
| To: | Gregory Maxwell <greg(at)z(dot)ml(dot)org>, "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:09:19 |
| Message-ID: | F10BB1FAF801D111829B0060971D839F5E1B68@cpsmail |
| 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.
So will a front anchored LIKE, but the query that was being performed
was an unanchored LIKE (i.e. '%stuff%').
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Maxwell | 1999-01-14 21:35:17 | RE: [GENERAL] non-case sensitive searches |
| Previous Message | Tim Williams | 1999-01-14 17:14:27 | Re: [GENERAL] Graphics Supported? |