[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] a strange order by behavior
From:       Pavel Stehule <pavel.stehule () gmail ! com>
Date:       2011-06-23 7:18:13
Message-ID: BANLkTimFEoxfLmegdzEiFq1wkarWSa7OZQ () mail ! gmail ! com
[Download RAW message or body]

2011/6/23 Peter Eisentraut <peter_e@gmx.net>:
> 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
>

ok, thank you

Pavel

>
>

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

[prev in list] [next in list] [prev in thread] [next in thread]