DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type:content-transfer-encoding;
	b=hr+wIUa164ZjokOgN12XMiGxPFGT6/y3rSk+FJ849PDIrf26fqkhSml6bZfTXyBJLg
	scKxFyOhB2MMCdaxsplzq3lv7JH2ChRcSjAVIYubKzFLzE1cKdJj4kxJKlM9jsLQ8BXY
	3QnK1OUGBxiM1nwya9KkrM5Y78hxlx/3cpYVc=
MIME-Version: 1.0
In-Reply-To: <1308773527.10498.7.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>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Thu, 23 Jun 2011 05:57:07 +0200
Message-ID: <BANLkTimUpGu04LW4ohAjvyU6Kkpee_2Y6Q@mail.gmail.com>
Subject: Re: a strange order by behavior
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Samuel Gendler <sgendler@ideasculptor.com>,
	Eyal Wilde <eyal@impactsoft.co.il>, pgsql-sql@postgresql.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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=3Ducs_basic -E UTF-8 test
>> createdb: database creation failed: ERROR: =C2=A0invalid locale name ucs=
_basic
>
> ucs_basic is a collation name, which is an SQL object. =C2=A0The argument=
 of
> createdb --lc-collate is an operating system locale name. =C2=A0You 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?

Regards

Pavel

>
>