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