| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Cc: | Samuel Gendler <sgendler(at)ideasculptor(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-23 07:18:13 |
| Message-ID: | BANLkTimFEoxfLmegdzEiFq1wkarWSa7OZQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
2011/6/23 Peter Eisentraut <peter_e(at)gmx(dot)net>:
> On tor, 2011-06-23 at 05:57 +0200, Pavel Stehule wrote:
>> 2011/6/22 Peter Eisentraut <peter_e(at)gmx(dot)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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Fabiani | 2011-06-23 15:44:49 | Union out performs the single statement |
| Previous Message | Peter Eisentraut | 2011-06-23 05:05:54 | Re: a strange order by behavior |