| From: | Marcel van Pinxteren <marcel(dot)van(dot)pinxteren(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Alex Hunsaker <badalex(at)gmail(dot)com>, Jasen Betts <jasen(at)xnet(dot)co(dot)nz>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Case insensitive collation |
| Date: | 2013-01-21 16:25:23 |
| Message-ID: | CAE3e+fM7iiBHwQXaZLaiTzWQw1Ge52r6H7AtQDmDXPiq=mXBbA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
To be honest, the reason I don't want to use citext and lower(), is me
being lazy. If I have to use these features, there is more work for me
converting from SQL Server to Postgresql. I have to make more changes to my
database, and more to my software.
But, developers are generally lazy, so you could argue that this reason is
"compelling".
The other reason, is that I assume that "lower()" adds overhead, so makes
things slower than they need to be.
Whether that is true, and if that is a compelling reason, I don't know.
Marcel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2013-01-21 16:44:44 | Re: Case insensitive collation |
| Previous Message | Scott Marlowe | 2013-01-21 16:17:01 | Re: Case insensitive collation |