Re: fast case-insensitive sort - Mailing list pgsql-sql

From Sigi Jekabsons
Subject Re: fast case-insensitive sort
Date
Msg-id 005801c302f8$6600a890$7c01a8c0@microvac
Whole thread Raw
In response to Re: fast case-insensitive sort  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Responses Re: fast case-insensitive sort  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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.
>



pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: fast case-insensitive sort
Next
From: Tom Lane
Date:
Subject: Re: fast case-insensitive sort