Re: Case Insensitive

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 <sameer(dot)kumar(at)ashnik(dot)com> wrote:

>
>
> On Thu, 28 Mar, 2019, 4:20 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 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:
ben(at)ausvet(dot)com(dot)au
Website:
www.ausvet.com.au
Skype: benmadin
Address:
5 Shuffrey Street
Fremantle, WA 6160
Australia