Re: case senesitive - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: case senesitive
Date
Msg-id Pine.LNX.4.21.0006111136440.353-100000@localhost.localdomain
Whole thread Raw
In response to case senesitive  (HENAFF Mari-mai FTRD/DMI/LAN <marimai.henaff@rd.francetelecom.fr>)
List pgsql-admin
HENAFF Mari-mai FTRD/DMI/LAN writes:

> And is it possible to make a query containing an ORDER BY that is not case
> sensitive ?

Option 1:

SELECT * FROM table ORDER BY upper(field);

Option 2:

Build with --enable-locale. Most locales sort a, A, b, B, etc.


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: multi processor
Next
From: Peter Eisentraut
Date:
Subject: Re: multi processor