Postgres FM
caSe-inSENsiTive
26:22
Nikolay and Michael discuss case-insensitive data — when we want to treat columns as case-insensitive, and the pros and cons of using citext, functions like lower(), or a custom collation. Here are some links to things they mentioned:
citext https://www.postgresql.org/docs/current/citext.html
Our episode on over-indexing https://postgres.fm/episodes/over-indexing
Nondeterministic collations…