Re: Case Insensitive

[Murtuza Zabuawala <murtuza.zabuawala@xxxxxxxxxxxxxxxx>]

On Thu, Mar 28, 2019 at 1:50 PM Sridhar N Bamandlapally <sridhar.bn1@xxxxxxxxx> 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