FullText Searching: The Dilemma

[Bradley Baetz]

On 27/06/07, Max Kanat-Alexander <mkanat at bugzilla.org> wrote:
> On Tue, 26 Jun 2007 15:34:09 +0100 Gervase Markham <gerv at mozilla.org>
> wrote:
> > We could do that. How hard would it be to convert b.m.o.? Are there
> > scripts, or do all conversions have to be done by hand? Do we know
> > how MoCo IT would feel about supporting Postgres? Do we feel the
> > Postgres support is stable enough? Are there other downsides?
>
>         We actually talked about it during the last upgrade, I believe.
>
>         The problem is that currently PostgreSQL is case-sensitive for
> searches, which is too much of a pain.
>
>         If there was a way to make the whole DB use a case-insensitive
> search and collation (and still be able to use indexes), we could do
> that.

Postgres supports functional indexes. So you create an index on
UPPER(column) and then a search WHERE UPPER(column) = 'FOO' will use
the index.

Not sure if the full text stuff does case insensitive directly.

Bradley