| From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
|---|---|
| To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Case sensitivity |
| Date: | 2013-12-11 16:17:50 |
| Message-ID: | CALSLE1MbLoGAJViNy_iw18oua8Mhx0HGtz7c+XKYyj4W34OeJA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers |
Actually for searches lower will work.
But the other important aspect is 'inserts' which would result 2 rows if
the values are 'A' and 'a'. Intent here to have it case insensitive.
If CITEXT it will update the same row and works.
CITEXT is an alternative but was wondering if there is any other alternate
solution/setting while creating database.
Also does CITEXT fetch via JDBC works the same way as fetch/set string
values? Any quick comments here.
http://techie-experience.blogspot.in/2013/04/hibernate-supporting-case-insensitive.html
Regards...
On Wed, Dec 11, 2013 at 8:58 PM, Andrew Sullivan <ajs(at)crankycanuck(dot)ca>wrote:
> On Wed, Dec 11, 2013 at 04:55:07PM +0530, Dev Kumkar wrote:
> You could build lower() indexes on any column you want to search CI
> and lower() all the input text during searches, in order to avoid any
> work on the schema. Bit of a kludge, though.
>
> Best,
>
> A
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tim Bruce - Postgres | 2013-12-11 19:00:41 | PG Foundry Down |
| Previous Message | Andrew Sullivan | 2013-12-11 15:28:21 | Re: Case sensitivity |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2013-12-11 16:28:18 | Re: Question about optimizing access to a table. |
| Previous Message | Sameer Kumar | 2013-12-11 15:55:37 | Re: Trigger Firing Order |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-12-11 16:24:01 | Re: -d option for pg_isready is broken |
| Previous Message | MauMau | 2013-12-11 16:09:01 | Re: [RFC] Shouldn't we remove annoying FATAL messages from server log? |