Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id AB9B9B5DBE1
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 22 Jun 2011 17:12:20 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 17088-10 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 22 Jun 2011 20:12:14 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mailout-de.gmx.net (mailout-de.gmx.net [213.165.64.23])
	by mail.postgresql.org (Postfix) with SMTP id 19162B5DC03
	for <pgsql-sql@postgresql.org>; Wed, 22 Jun 2011 17:12:13 -0300 (ADT)
Received: (qmail invoked by alias); 22 Jun 2011 20:12:12 -0000
Received: from a88-115-218-165.elisa-laajakaista.fi (EHLO [10.0.0.101])
	[88.115.218.165]
	by mail.gmx.net (mp003) with SMTP; 22 Jun 2011 22:12:12 +0200
X-Authenticated: #495269
X-Provags-ID: V01U2FsdGVkX18Sb65vK+IS500qoYdU+nwfwUD0D9aCdT9pOZTQow
	nrdJShpb/5huzS
Subject: Re: a strange order by behavior
From: Peter Eisentraut <peter_e@gmx.net>
To: Samuel Gendler <sgendler@ideasculptor.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, Eyal Wilde
	<eyal@impactsoft.co.il>,  pgsql-sql@postgresql.org
In-Reply-To: <BANLkTi=7Lqyj4LbRPHp1mLo_0-mFN5XPmA@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>
Content-Type: text/plain; charset="UTF-8"
Date: Wed, 22 Jun 2011 23:12:07 +0300
Message-ID: <1308773527.10498.7.camel@vanquo.pezone.net>
Mime-Version: 1.0
X-Mailer: Evolution 2.32.3 
Content-Transfer-Encoding: 7bit
X-Y-GMX-Trusted: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.909 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201106/85
X-Sequence-Number: 35551

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.