Postgres Pro
Downloads
Home   >   mailing lists

Re: fast case-insensitive sort - Mailing list pgsql-sql

From Tom Lane
Subject Re: fast case-insensitive sort
Date
Msg-id 5728.1050388714@sss.pgh.pa.us
Whole thread Raw
In response to Re: fast case-insensitive sort  ("Sigi Jekabsons" <sigi.j@workskillsprofessionals.com.au>)
List pgsql-sql
Tree view 
"Sigi Jekabsons" <sigi.j@workskillsprofessionals.com.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

pgsql-sql by date:

Previous
From: "Sigi Jekabsons"
Date:
Subject: Re: fast case-insensitive sort
Next
From: Rado Petrik
Date:
Subject: atomatic insert date and time