From: | Murtuza Zabuawala <murtuza(dot)zabuawala(at)enterprisedb(dot)com> |
---|---|
To: | Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com> |
Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Case Insensitive |
Date: | 2019-03-28 08:27:28 |
Message-ID: | CAKKotZQs3yrhtBCXX8BppotKij6tzRBkbjB=CLQGGRuRF3Qduw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On Thu, Mar 28, 2019 at 1:50 PM Sridhar N Bamandlapally <
sridhar(dot)bn1(at)gmail(dot)com> wrote:
> Hi PG-General and Pgsql-Admin
>
> Can we achieve CASE INSENSITIVE in PostgreSQL?
>
You can try
*select * from emp where ename *ILIKE *'aaa';*
>
> 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 | Andreas Kretschmer | 2019-03-28 08:28:38 | Re: Case Insensitive |
Previous Message | Ben Madin | 2019-03-28 08:26:30 | Re: Case Insensitive |
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2019-03-28 08:28:38 | Re: Case Insensitive |
Previous Message | Ben Madin | 2019-03-28 08:26:30 | Re: Case Insensitive |