>>>>> "Natalie" == Natalie Wenz <nataliewenz@gmail.com> writes:
Natalie> Thanks, Andrew.
Natalie> All of our databases do have lc_collate=C. To check my
Natalie> understanding, if that were not the case, we’d need to
Natalie> reindex, but since it is all lc_collate=C, we shouldn’t run
Natalie> into that particular problem. Did I get that right?
To be completely precise, it's not enough to have lc_collate=C, you also
need to not have indexed columns with individually specified non-default
collations. i.e. what matters is not so much the database setting, but
the actual collation being used for indexed columns (because it's the
collation that determines the order in which values appear in the
index).
--
Andrew (irc:RhodiumToad)