From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Sigi Jekabsons <sigi.j@workskillsprofessionals.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: fast case-insensitive sort
Date: Mon, 14 Apr 2003 19:21:45 -0700 (PDT)
Message-ID: <20030414191817.L48398-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <002e01c302e8$db771ab0$7c01a8c0@microvac>
On Tue, 15 Apr 2003, Sigi Jekabsons wrote:
> I'm having trouble getting postgres to use an index when doing an ORDER BY
> UPPER(surname), for instance. I can create an index on UPPER(surname), but
> it doesn't use it in the query - is there a better way of doing a fast case
> insensitive sort?
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.
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: sszabo@megazone23.bigpanda.com, sigi.j@workskillsprofessionals.com.au
Subject: Re: fast case-insensitive sort
In-Reply-To: <20030414191817.L48398-100000@megazone23.bigpanda.com>
* 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