From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sigi Jekabsons <sigi.j@workskillsprofessionals.com.au>
Cc: pgsql-sql@postgresql.org, "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
Subject: Re: fast case-insensitive sort
Date: Tue, 15 Apr 2003 01:54:58 -0400
Message-ID: <5353.1050386098@sss.pgh.pa.us> (raw)
In-Reply-To: <005801c302f8$6600a890$7c01a8c0@microvac>
References: <20030414191817.L48398-100000@megazone23.bigpanda.com>
<005801c302f8$6600a890$7c01a8c0@microvac>
"Sigi Jekabsons" <sigi.j@workskillsprofessionals.com.au> writes:
> '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?
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, sigi.j@workskillsprofessionals.com.au, sszabo@megazone23.bigpanda.com
Subject: Re: fast case-insensitive sort
In-Reply-To: <5353.1050386098@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox