Re: Simple Question: Case sensitivity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomas Berndtsson <tomas(at)nocrew(dot)org>
Cc: "Hancock, David (DHANCOCK)" <DHANCOCK(at)arinc(dot)com>, "'pgsql-general(at)postgresql(dot)org '" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Simple Question: Case sensitivity
Date: 2000-12-11 15:41:35
Message-ID: 7306.976549295@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tomas Berndtsson <tomas(at)nocrew(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message martin.chantler 2000-12-11 15:43:59 Re: Simple Question: Case sensitivity - Performance?
Previous Message Michael Ansley 2000-12-11 15:41:13 RE: Regular expression question