Re: fast case-insensitive sort

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sigi Jekabsons" <sigi(dot)j(at)workskillsprofessionals(dot)com(dot)au>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: fast case-insensitive sort
Date: 2003-04-15 06:38:34
Message-ID: 5728.1050388714@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Sigi Jekabsons" <sigi(dot)j(at)workskillsprofessionals(dot)com(dot)au> writes:
> 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),

That's the best immediate workaround, for sure.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Rado Petrik 2003-04-15 08:58:48 atomatic insert date and time
Previous Message Sigi Jekabsons 2003-04-15 06:28:26 Re: fast case-insensitive sort