On Tue, 15 Apr 2003, Sigi Jekabsons wrote:
> I'm having trouble getting postgres to use an index when doing an ORDER BY
> UPPER(surname), for instance. I can create an index on UPPER(surname), but
> it doesn't use it in the query - is there a better way of doing a fast case
> insensitive sort?
What's the table look like (what type is surname)? I can get behavior
like this using a varchar, but it uses the index when the field is
declared as text.