3 ms·
What I feel lacking in PG(though it can be easily managed by adding respective plugins) is the lack of unsigned int alike (from MySQL) AND UNIQUE columns be cas
by iKevinShah 8y ago
What I feel lacking in PG(though it can be easily managed by adding respective plugins) is the lack of unsigned int alike (from MySQL) AND UNIQUE columns be case-insensitive or an option of having case-insensitive unique columns while default be case-sensitive (As it is currently)
- bmdavi3 8y agoThere'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]
- Deimorz 8y agoYou can do case-insensitive columns by enabling the "citext" module, which is included but not enabled by default: https://www.postgresql.org/docs/current/static/citext.html https://www.postgresql.org/docs/current/static/citext.html