| 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 03:57:07 |
| Message-ID: | BANLkTimUpGu04LW4ohAjvyU6Kkpee_2Y6Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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?
Regards
Pavel
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Samuel Gendler | 2011-06-23 04:34:34 | Re: a strange order by behavior |
| Previous Message | Peter Eisentraut | 2011-06-22 20:12:07 | Re: a strange order by behavior |