3 ms·
There's no 'CASE INSENSITIVE' option for unique indexes, but you can unique on lower(my_column) to achieve the safe effect.
by bmdavi3 8y ago
There's no 'CASE INSENSITIVE' option for unique indexes, but you can unique on lower(my_column) to achieve the safe effect.
- iKevinShah 8y agoyes that is what I do currently as a workaround. I wished we had an option for case-insensitive unique indexes though..
- deleted 8y ago[deleted]