Case insensitve sort

From: "Umashanker, Srividhya" <srividhya(dot)umashanker(at)hp(dot)com>
To: "pgeu-general(at)postgresql(dot)org" <pgeu-general(at)postgresql(dot)org>
Subject: Case insensitve sort
Date: 2013-03-20 06:44:59
Message-ID: 5D5078F9198B04449B9D74EA9E7F3D580CD246F1@G1W3640.americas.hpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgeu-general

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?

[cid:image001(dot)png(at)01CE2564(dot)89C1F470]
-Vidhya

Responses

Browse pgeu-general by date

  From Date Subject
Next Message Hans-Jürgen Schönig 2013-03-20 07:33:13 Re: Case insensitve sort
Previous Message Umashanker, Srividhya 2013-03-20 06:34:05 Alphanumeric natural order sorting