Madison Kelly <[EMAIL PROTECTED]> writes: > Can anyone see why the index might not be being used?
You didn't initdb in 'C' locale. You can either re-initdb, or create a specialized index with a non-default operator class to support LIKE. See the documentation. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings