From: Pavel Stehule <pavel.stehule@gmail.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Samuel Gendler <sgendler@ideasculptor.com>
Cc: Eyal Wilde <eyal@impactsoft.co.il>
Cc: pgsql-sql@postgresql.org
Subject: Re: a strange order by behavior
Date: Thu, 23 Jun 2011 09:18:13 +0200
Message-ID: <BANLkTimFEoxfLmegdzEiFq1wkarWSa7OZQ@mail.gmail.com> (raw)
In-Reply-To: <1308805554.22303.0.camel@vanquo.pezone.net>
References: <BANLkTi=ScMyF7nHQ6nhbyYr9UDrq16U=9g@mail.gmail.com>
<BANLkTi=PXV+FrAJHHX56D41Xo4DzG7vADA@mail.gmail.com>
<BANLkTim9sFLt3e2+auF_oTr68UETiW83VA@mail.gmail.com>
<BANLkTi=7Lqyj4LbRPHp1mLo_0-mFN5XPmA@mail.gmail.com>
<1308773527.10498.7.camel@vanquo.pezone.net>
<BANLkTimUpGu04LW4ohAjvyU6Kkpee_2Y6Q@mail.gmail.com>
<1308805554.22303.0.camel@vanquo.pezone.net>
2011/6/23 Peter Eisentraut <peter_e@gmx.net>:
> On tor, 2011-06-23 at 05:57 +0200, Pavel Stehule wrote:
>> 2011/6/22 Peter Eisentraut <peter_e@gmx.net>:
>> > On ons, 2011-06-22 at 02:39 -0700, Samuel Gendler wrote:
>> >> Pavel suggested using a collation of ucs_basic, but I get an error
>> >> when I
>> >> try that on linux:
>> >>
>> >> $ createdb -U u1 --lc-collate=ucs_basic -E UTF-8 test
>> >> createdb: database creation failed: ERROR: invalid locale name ucs_basic
>> >
>> > ucs_basic is a collation name, which is an SQL object. The argument of
>> > createdb --lc-collate is an operating system locale name. You can't mix
>> > the two, even though they are similar.
>> >
>>
>> ok, what I can to select, when I would to use a C like default order?
>
> createdb --locale=C --encoding=UTF8
>
ok, thank you
Pavel
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pavel.stehule@gmail.com, peter_e@gmx.net, sgendler@ideasculptor.com, eyal@impactsoft.co.il
Subject: Re: a strange order by behavior
In-Reply-To: <BANLkTimFEoxfLmegdzEiFq1wkarWSa7OZQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox