Re: sort order - Mailing list pgsql-general

From Tom Lane
Subject Re: sort order
Date
Msg-id 19622.1323706039@sss.pgh.pa.us
Whole thread Raw
In response to Re: sort order  ("Abraham, Danny" <danny_abraham@bmc.com>)
Responses Re: sort order  ("Abraham, Danny" <danny_abraham@bmc.com>)
List pgsql-general
"Abraham, Danny" <danny_abraham@bmc.com> writes:
> This is exactly what I am trying to do -
> To find a CREATE DATABASE statement that will produce a database that has a binary sorting.

Setting its LC_COLLATE to "C" ought to do that.

BTW, as of 9.1 you can control this at finer granularity than database
level, see the COLLATE clause.

            regards, tom lane

pgsql-general by date:

Previous
From: Joe Miller
Date:
Subject: Re: PostgreSQL DBA in SPAAAAAAAACE
Next
From: Adrian Klaver
Date:
Subject: Re: sort order