Re: fast case-insensitive sort

The table 'cands' has a 'cand_id' int4 primary key, indexed and specified
unique.  'surname' is varchar(255), indexed in the manner shown on my
previous post.  You're quite right, though, I just tried indexing and
sorting by a column of type text and that worked just fine, it used the
index in the order by.  Why is that?

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