Subject: Re: a strange order by behavior
From: Peter Eisentraut <peter_e@gmx.net>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: Samuel Gendler <sgendler@ideasculptor.com>, Eyal Wilde
	<eyal@impactsoft.co.il>, pgsql-sql@postgresql.org
In-Reply-To: <BANLkTimUpGu04LW4ohAjvyU6Kkpee_2Y6Q@mail.gmail.com>
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>
Content-Type: text/plain; charset="UTF-8"
Date: Thu, 23 Jun 2011 08:05:54 +0300
Message-ID: <1308805554.22303.0.camel@vanquo.pezone.net>
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit

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