| From: | Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
|---|---|
| To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Case Insensitive |
| Date: | 2019-03-28 08:20:07 |
| Message-ID: | CAGuFTBU1fACZWYdVwU-HiBJWAt2QFRa9fkB+SovmVMoUjVbekw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
Hi PG-General and Pgsql-Admin
Can we achieve CASE INSENSITIVE in PostgreSQL?
I mean, need below way
postgres=# select * from emp;
eid | ename
-----+-------
1 | aaa
2 | AAA
(2 rows)
*postgres=# select * from emp where ename='aaa';*
* eid | ename*
*-----+-------*
* 1 | aaa*
* 2 | AAA*
*(2 rows)*
*--above result is just an manual made example only*
Thanks
Sridhar
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Kumar | 2019-03-28 08:23:52 | Re: Case Insensitive |
| Previous Message | Alexander Shaburov | 2019-03-28 07:45:07 | Re: Long running query in new production, not so long in old |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sameer Kumar | 2019-03-28 08:23:52 | Re: Case Insensitive |
| Previous Message | David G. Johnston | 2019-03-27 16:37:03 | Re: Is it possible to have a cascade upwards query? |