Would this also select characters with diacritical marks? For example, eid | ename -----+------- 1 | aaa 2 | AAA 3 | áäâ 4 | āåȧ
— Andy > On Mar 28, 2019, at 4:26 AM, Ben Madin <b...@ausvet.com.au> wrote: > > Or you can just use `ilike`: > > SELECT * FROM emp WHERE ename ilike 'aaa'; > > https://www.postgresql.org/docs/10/sql-select.html#SQL-WHERE > <https://www.postgresql.org/docs/10/sql-select.html#SQL-WHERE> > > cheers > > Ben > > On Thu, 28 Mar 2019 at 16:24, Sameer Kumar <sameer.ku...@ashnik.com > <mailto:sameer.ku...@ashnik.com>> wrote: > > > On Thu, 28 Mar, 2019, 4:20 PM Sridhar N Bamandlapally, <sridhar....@gmail.com > <mailto:sridhar....@gmail.com>> 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 > > > > -- > > <https://www.ausvet.com.au/> > > Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD > Managing Director > Mobile: +61 448 887 220 <tel:+61448887220> > E-mail: b...@ausvet.com.au <mailto:b...@ausvet.com.au> > Website: www.ausvet.com.au <https://www.ausvet.com.au/> > Skype: benmadin <> > Address: 5 Shuffrey Street > Fremantle, WA 6160 > Australia
signature.asc
Description: Message signed with OpenPGP