| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Case sensitivity |
| Date: | 2013-12-11 15:28:21 |
| Message-ID: | 20131211152821.GC35381@crankycanuck.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers |
On Wed, Dec 11, 2013 at 04:55:07PM +0530, Dev Kumkar wrote:
> creating database. I have been looking at other discussions and doesn't
> look like anything of that coming up soon that makes database case
> insensitive.
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
--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dev Kumkar | 2013-12-11 16:17:50 | Re: Case sensitivity |
| Previous Message | Dev Kumkar | 2013-12-11 15:16:25 | Re: Case sensitivity |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | salah jubeh | 2013-12-11 15:29:25 | Re: Convert table to view 9.1 |
| Previous Message | Dev Kumkar | 2013-12-11 15:16:25 | Re: Case sensitivity |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-12-11 15:30:07 | Re: Question about sorting internals |
| Previous Message | Simon Riggs | 2013-12-11 15:16:50 | Re: ANALYZE sampling is too good |