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