Re: Case Insensitive - Mailing list 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.