Or you can just use `ilike`: SELECT * FROM emp WHERE ename ilike 'aaa';
https://www.postgresql.org/docs/10/sql-select.html#SQL-WHERE cheers Ben On Thu, 28 Mar 2019 at 16:24, Sameer Kumar <[email protected]> wrote: > > > On Thu, 28 Mar, 2019, 4:20 PM Sridhar N Bamandlapally, < > [email protected]> wrote: > >> Hi PG-General and Pgsql-Admin >> >> Can we achieve CASE INSENSITIVE in PostgreSQL? >> > > You are perhaps migrating from another RDBMS where this kind of feature is > considered a feature. > > > >> 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* >> >> > You can write a query with upper function: > > select * from emp where upper(ename)=upper('aaa'); > > Or you can overload the "=" operator for text arguements. > > > >> Thanks >> Sridhar >> >> -- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director Mobile: +61 448 887 220 <+61448887220> E-mail: [email protected] Website: www.ausvet.com.au Skype: benmadin Address: 5 Shuffrey Street Fremantle, WA 6160 Australia
