Wes <wespvp@xxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster