Thanks for that. Is it recommended, then, that I use type of text on
columns that I intend to sort with an index on UPPER(column), or is there
something else I should be doing?
> I would have said that the presence of the implicit varchar-to-text cast
> prevented the system from detecting that the expression matches the
> index value. But if it's able to detect the match in one case and not
> the other, that might be a garden-variety bug. Will look at it ...
>
> regards, tom lane
>
>