Re: Case Insensitive

[Andy Anderson <aanderson@xxxxxxxxxxx>]

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 <ben@xxxxxxxxxxxxx> 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

cheers

Ben

On Thu, 28 Mar 2019 at 16:24, Sameer Kumar <sameer.kumar@xxxxxxxxxx> wrote:

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

--

Dr Ben Madin

 

BVMS MVPHMgmt PhD MANZCVS GAICD

Managing Director

Mobile:

+61 448 887 220

E-mail:

ben@xxxxxxxxxxxxx

Website:

www.ausvet.com.au

Skype: benmadin

Address: 

5 Shuffrey Street
Fremantle, WA 6160
Australia

Attachment: signature.asc
Description: Message signed with OpenPGP