Re: Simple Question: Case sensitivity - Mailing list pgsql-general

From Tom Lane
Subject Re: Simple Question: Case sensitivity
Date
Msg-id 7306.976549295@sss.pgh.pa.us
Whole thread Raw
In response to Re: Simple Question: Case sensitivity  (Tomas Berndtsson <tomas@nocrew.org>)
List pgsql-general
Tomas Berndtsson <tomas@nocrew.org> writes:
>> This index will be considered for queries like:
>>
>> play=> explain select * from foo where upper(f1) = 'z';

> Don't you need upper('z')?

yup ... or at least 'Z' ... sloppy example :-(

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Ansley
Date:
Subject: RE: Simple Question: Case sensitivity
Next
From: "Robert D. Nelson"
Date:
Subject: RE: Re: Re: Why PostgreSQL is not that popular as My