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