Re: Case Insensitive

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Case Insensitive
Date: 2019-03-28 08:29:55
Message-ID: c86c6b09-31fa-f27d-b373-3d604d4ca2a0@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Atkins 2019-03-28 08:33:01 Re: Case Insensitive
Previous Message Andreas Kretschmer 2019-03-28 08:28:38 Re: Case Insensitive

Browse pgsql-general by date

  From Date Subject
Next Message Steve Atkins 2019-03-28 08:33:01 Re: Case Insensitive
Previous Message Andreas Kretschmer 2019-03-28 08:28:38 Re: Case Insensitive