X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3A70C47580B for ; Mon, 14 Apr 2003 22:39:53 -0400 (EDT) Received: from workskillsprofessionals.com.au (adsl-202-72-167-48.prem.westnet.com.au [202.72.167.48]) by postgresql.org (Postfix) with ESMTP id 97D51474E44 for ; Mon, 14 Apr 2003 22:39:51 -0400 (EDT) Received: from microvac [192.168.1.124] by workskillsprofessionals.com.au [192.168.1.188] with SMTP (MDaemon.PRO.v4.0.5.R) for ; Tue, 15 Apr 2003 10:48:06 +0800 Message-ID: <005801c302f8$6600a890$7c01a8c0@microvac> From: "Sigi Jekabsons" To: Cc: "Stephan Szabo" References: <20030414191817.L48398-100000@megazone23.bigpanda.com> Subject: Re: fast case-insensitive sort Date: Tue, 15 Apr 2003 10:40:38 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-MDRemoteIP: 192.168.1.124 X-Return-Path: sigi.j@workskillsprofessionals.com.au X-MDaemon-Deliver-To: pgsql-sql@postgresql.org X-Spam-Status: No, hits=-9.7 required=5.0 tests=QUOTED_EMAIL_TEXT,REFERENCES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/217 X-Sequence-Number: 12918 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. >