Re: a strange order by behavior

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Samuel Gendler <sgendler(at)ideasculptor(dot)com>
Cc: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Eyal Wilde <eyal(at)impactsoft(dot)co(dot)il>, pgsql-sql(at)postgresql(dot)org
Subject: Re: a strange order by behavior
Date: 2011-06-22 20:12:07
Message-ID: 1308773527.10498.7.camel@vanquo.pezone.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2011-06-23 03:57:07 Re: a strange order by behavior
Previous Message Peter Eisentraut 2011-06-22 20:10:15 Re: a strange order by behavior