3 ms·
Because you don't always want to match 'Foo' to 'foo'?
by thejosh 9y ago
Because you don't always want to match 'Foo' to 'foo'?
- jakobegger 9y agoThat's what per-column collations are for. Ideally you should be able to choose from case sensitive and case insensitive collations. Unfortunately PostgreSQL doesn't support case insensitive collations (for some reason the string comparison routines use memcmp as a tie-breaker when the collation says strings are equal).