Re: a strange order by behavior - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: a strange order by behavior
Date
Msg-id BANLkTimUpGu04LW4ohAjvyU6Kkpee_2Y6Q@mail.gmail.com
Whole thread Raw
In response to Re: a strange order by behavior  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: a strange order by behavior  (Samuel Gendler <sgendler@ideasculptor.com>)
Re: a strange order by behavior  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
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?

Regards

Pavel

>
>


pgsql-sql by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: a strange order by behavior
Next
From: Samuel Gendler
Date:
Subject: Re: a strange order by behavior