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 1h9QQE-0002K3-KX for pgsql-general@arkaria.postgresql.org; Thu, 28 Mar 2019 08:30:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h9QQD-0006e9-Dr for pgsql-general@arkaria.postgresql.org; Thu, 28 Mar 2019 08:30:01 +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 1h9QQC-0006aa-RE for pgsql-general@lists.postgresql.org; Thu, 28 Mar 2019 08:30:01 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h9QQA-0001fe-Fh for pgsql-general@lists.postgresql.org; Thu, 28 Mar 2019 08:29:59 +0000 Received: by mail-ot1-x32c.google.com with SMTP id 103so17515887otd.9 for ; Thu, 28 Mar 2019 01:29:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=keiceU/xfEzZ2KTo4bjn9QSEY6otuDjn4W0Rb99sUPM=; b=ukGom7CsxXso3Y7X0gHxRUr1c8koyJOSWOxSHZ8T4fCcFexhN3GU5qGYmWaOiv36y/ 7fpnFA+6AbTnbpK2vCg+DQJW9jib4eoIvw1enCrJfjWUJV4MnUePnW+bEn3DO8dbL1+5 ewIn1w/NTmTAWQhhrPh6BnfBzgfkTTUUOOFA1mQg1ik65ZSLRipIKPje+2Ygqy1UZxcW tfwijZvoJSmgTLY7ZJGGbu44ewiAcJNGsZNOayZEzjzKMG2XPSOkatUGLiI7HI1rKZKI Lum1BmUFW7yBjbiAnl7JATmn9rPICNoa2avKBTlh+gVK5DBKFgChTCw0EZSbKHCy+x+6 O4tw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=keiceU/xfEzZ2KTo4bjn9QSEY6otuDjn4W0Rb99sUPM=; b=C3V/u1J74uljUZ8Uq17zmDFZi/WNdremR40rs2+GaSRwSeAT7jf3br7RHmaFA/bnMC gQKSFU+ZkFhMrZFO26wd5H0iEoxK3OgwJH3BUCdAIrVoKA03Xj9YvfOEjqzSA85hWi+w saeQ8VII29E6z5YESB6UtRP+OzEEg2Pp8yYrlNcy3lnFkr/m9d4UhtEf0HeI28S2sY/D SUbmxQTGxpziv6pPBKOB8WlikjShACQv4xdc+mXFqM9LJsEogwRyvbWeSAG+ib3Svewe fRu96j5FxL4gdhEFgR9WJ3im+kXChcEV04aMSHs+z/hIG4moBAJHfGjZSeSXObElj2Uv c9jA== X-Gm-Message-State: APjAAAXNVSpp6c82MBAy+ceBydrIYKTcJtz9veQc3Sdc6UlJaBb8CODm +y017fmitmBQnjLmp/eHoWMtKf7Cg58Kvw== X-Google-Smtp-Source: APXvYqyCoGL8V9j5rnbMaxWv+/mWGtdscWq4jsJdX2r2DYF/jpFXzszvXc54/aqsMOA/n5SOtPuRcw== X-Received: by 2002:a9d:6c45:: with SMTP id g5mr30799485otq.54.1553761797280; Thu, 28 Mar 2019 01:29:57 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id p186sm1252239oif.34.2019.03.28.01.29.56 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 28 Mar 2019 01:29:56 -0700 (PDT) Subject: Re: Case Insensitive To: pgsql-general@lists.postgresql.org References: From: Ron Message-ID: Date: Thu, 28 Mar 2019 03:29:55 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------C9D38EA9741E94E640A63065" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------C9D38EA9741E94E640A63065 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit On 3/28/19 3:23 AM, Sameer Kumar wrote: [snip] > You can write a query with upper function: > > select * from emp where upper(ename)=upper('aaa'); That's a guaranteed table scan. -- Angular momentum makes the world go 'round. --------------C9D38EA9741E94E640A63065 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit On 3/28/19 3:23 AM, Sameer Kumar wrote:
[snip]
You can write a query with upper function:

select * from emp where upper(ename)=upper('aaa');

That's a guaranteed table scan.


--
Angular momentum makes the world go 'round.
--------------C9D38EA9741E94E640A63065--