Re: fast case-insensitive sort

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
>
>