New answers tagged casesensitive
Index usage with text_pattern_ops (as well as with the default operator class when using the C locale) depends on the binary representation of character data. citext stores original values with the case preserved, so there must be a problem with that ... Like you commented, the actual reason is burried in collation support. Either way, citext or text, you ...
Top 50 recent answers are included