Re: sort order

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: sort order
Date: 2011-12-12 16:07:19
Message-ID: 19622.1323706039@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Abraham, Danny" <danny_abraham(at)bmc(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-12-12 16:09:11 Re: sort order
Previous Message Joe Miller 2011-12-12 16:03:31 Re: PostgreSQL DBA in SPAAAAAAAACE