Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9Smf-0002b0-VC for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2019 11:01:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9Sme-0002wl-My for pgsql-admin@arkaria.postgresql.org; Thu, 28 Mar 2019 11:01:20 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9Sme-0002v9-Ad for pgsql-admin@lists.postgresql.org; Thu, 28 Mar 2019 11:01:20 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_CAMELLIA_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9Sma-0005NA-T6 for pgsql-admin@lists.postgresql.org; Thu, 28 Mar 2019 11:01:18 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 692B4BE14E0 for ; Thu, 28 Mar 2019 12:01:14 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at rs.plausibolo.de Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 7M96QkjQ6S9z; Thu, 28 Mar 2019 12:01:08 +0100 (CET) Received: from [192.168.178.12] (i577BC5E5.versanet.de [87.123.197.229]) by rs.plausibolo.de (Postfix) with ESMTPSA id 2E3C9BE14D9; Thu, 28 Mar 2019 12:01:08 +0100 (CET) Subject: Re: Case Insensitive To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs Openpgp: preference=signencrypt Autocrypt: addr=holger@jakobs.com; prefer-encrypt=mutual; keydata= mQGiBEG8IA8RBAC6WqUzEPTjest7MvFca5WlI47EgtKzOy1D1X9gSEmPj0sQrilNGEitY/+Q kPnCvI3odz1XXf/MZQtXwlxJA4lPmx8/K7MqBj9vh0J5jRznpE7l+SBDmmDobIqBAgl6BZvH 1C7e2y72h5T1/plrXonLUGzthqBtsvWl0ogoyTJqiwCg6AOhYX+Xbcl8/AXy4F4qbUq4LXsD /j6yCKRkyleN688y9YpuS5J6/ZZ/OBCM74pa2iNge3GmXn1JeUowF693QFCGHkpswmDIoGhL 5iM6GHj9HFB6rTXW5H3sR1y6ta7vXwoNBGkgiM89B1a/KsLT5L6MZgZ5AV0tj6vxwAsuLixS SDiNVNAd8vp2FfqdLlOgThsgVIwKBACsCzZa1VxpdoNSYnkTOSZhEjZkbWApdneQ2bTxXJgW +fWgVeLiojCp6I1AmQqzwHz8UN1nrsQjH8Rnxt2J/C5H/Ek9jlOFakFQXlPMZw3tNeTA1P3B 3zPyq6hKFPZHFklUquE3gHVjnX9qxSW0xvFirf6xAMCMYWRnCQHRgiXoAbQhSG9sZ2VyIEph a29icyA8aG9sZ2VyQGpha29icy5jb20+iGQEExECACQCGwMGCwkIBwMCAxUCAwMWAgECHgEC F4AFAlZ7KnEFCSeLDWIACgkQileck7MZYbpbxgCgxM54+4qx/sfGwq01x93pWr2QghwAoIfD Of6Uoc43y98+xR5/Iu9Z1RH8uQENBEG8IBAQBACiGkoX8HKCocdCwRdMzc9siDs1w0YNayhT PnK9Ii3wzzS2R9NSyWsPQVyx6hkVfSmK6CE5RzfuDUzrYEgyaV/2vT3JD9Gko+RuFnjeQvVo 8hc19bmBSn95ATki+hFy/68MqpMlsG7YyCluRSpXh2qxlhbh2FzTIQmiEQAR4kFCEwADBQP/ Z1Y6nwoXw/5JmLJLFcvZZlFfn4g9TjyMSwH50/AXqOApccy9JSzoTFY87ItmGkhD0qj18PJB St2uqASGrk2/55XK596RWnoeyL9mzj5r6woDqPNRXIbK85foGVIMRrb/EufgSOP5H6VHybvB PD4CppEw4Q0fRsMCaOcvibkjHoqITwQYEQIADwIbDAUCVnsqcQUJJ4sNYQAKCRCKV5yTsxlh urunAJ9avyijdRls7l6XPc2cBMys3xu/sgCeOVJE6DzwBBRUd6S6mtf2eG4FPXg= Message-ID: <3ce3221c-a3f3-cad4-ce99-569902e41d31@jakobs.com> Date: Thu, 28 Mar 2019 12:01:07 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.5.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------D829C4E3C1A5E58D6A6A419D" Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------D829C4E3C1A5E58D6A6A419D Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Yes, you can use the data type citext https://www.postgresql.org/docs/current/citext.html If you don't want to do this, you will have to compare /where lower(ename)='aaa'/ / / Am 28.03.19 um 09:20 schrieb Sridhar N Bamandlapally: > Hi PG-General and Pgsql-Admin > > Can we achieve CASE INSENSITIVE in PostgreSQL? > > 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 > -- Holger Jakobs, Bergisch Gladbach instant messaging: xmpp:holger@jakobs.com +49 178 9759012 oder +49 2202 817157 --------------D829C4E3C1A5E58D6A6A419D Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Yes, you can use the data type citext

https://www.postgresql.org/docs/current/citext.html

If you don't want to do this, you will have to compare where lower(ename)='aaa'


Am 28.03.19 um 09:20 schrieb Sridhar N Bamandlapally:
Hi PG-General and Pgsql-Admin

Can we achieve CASE INSENSITIVE in PostgreSQL?

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

--

Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@jakobs.com
+49 178 9759012 oder +49 2202 817157

--------------D829C4E3C1A5E58D6A6A419D--