There's no 'CASE INSENSITIVE' option for unique indexes, but you can unique on l... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

bmdavi3 on Aug 29, 2018 | parent | context | favorite | on: A Missing Link in Postgres 11: Fast Column Creatio...

There's no 'CASE INSENSITIVE' option for unique indexes, but you can unique on lower(my_column) to achieve the safe effect.

iKevinShah on Aug 29, 2018 [–]

yes that is what I do currently as a workaround. I wished we had an option for case-insensitive unique indexes though..

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact