Re: Indexed leading substring searches - worked, now doesn't - Mailing list pgsql-general

From Tom Lane
Subject Re: Indexed leading substring searches - worked, now doesn't
Date
Msg-id 5638.1107469931@sss.pgh.pa.us
Whole thread Raw
In response to Re: Indexed leading substring searches - worked, now  (Wes <wespvp@syntegra.com>)
List pgsql-general
Wes <wespvp@syntegra.com> writes:
> As an interim solution until I can reload the database (takes a weekend),
> can I define two indexes on the same field, one using operator classes and
> one not (and have them automatically used as appropriate)?

Certainly.

            regards, tom lane

pgsql-general by date:

Previous
From: Pritesh Shah
Date:
Subject: errors while restoring data.
Next
From: Tom Lane
Date:
Subject: Re: errors while restoring data.