| From: | Hans-Jürgen Schönig <hs(at)cybertec(dot)at> |
|---|---|
| To: | "Umashanker, Srividhya" <srividhya(dot)umashanker(at)hp(dot)com> |
| Cc: | "pgeu-general(at)postgresql(dot)org" <pgeu-general(at)postgresql(dot)org> |
| Subject: | Re: Case insensitve sort |
| Date: | 2013-03-20 07:33:13 |
| Message-ID: | 3B3F0783-1B07-476A-9FFF-EB57E5028CF8@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgeu-general |
On Mar 20, 2013, at 7:44 AM, Umashanker, Srividhya wrote:
> Using Postgres 9.2
>
> Is there a database configuration to do case insensitive sort using collation?
> We are using (given below) UPPER/LOWER to do case-insensitive sort. Is there a better approach?
hello ...
the easiest way is to use a data type called "citext".
you can do ...
CREATE EXTENSION citext;
to enable the module and use citext as simple column type then.
regards,
hans
--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26
A-2700 Wiener Neustadt, Austria
Web: http://www.postgresql-support.de
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2013-03-20 08:13:17 | Re: Alphanumeric natural order sorting |
| Previous Message | Umashanker, Srividhya | 2013-03-20 06:44:59 | Case insensitve sort |