X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 20135474E44 for ; Tue, 15 Apr 2003 02:29:09 -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 ACEE5476347 for ; Tue, 15 Apr 2003 02:29:06 -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 14:35:55 +0800 Message-ID: <007001c30318$395bc5c0$7c01a8c0@microvac> From: "Sigi Jekabsons" To: References: <20030414191817.L48398-100000@megazone23.bigpanda.com> <005801c302f8$6600a890$7c01a8c0@microvac> <5353.1050386098@sss.pgh.pa.us> Subject: Re: fast case-insensitive sort Date: Tue, 15 Apr 2003 14:28:26 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" 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/219 X-Sequence-Number: 12920 Thanks for that. Is it recommended, then, that I use type of text on columns that I intend to sort with an index on UPPER(column), or is there something else I should be doing? > I would have said that the presence of the implicit varchar-to-text cast > prevented the system from detecting that the expression matches the > index value. But if it's able to detect the match in one case and not > the other, that might be a garden-variety bug. Will look at it ... > > regards, tom lane > >