Re: a strange order by behavior
От | Peter Eisentraut |
---|---|
Тема | Re: a strange order by behavior |
Дата | |
Msg-id | 1308805554.22303.0.camel@vanquo.pezone.net обсуждение исходный текст |
Ответ на | Re: a strange order by behavior (Pavel Stehule <pavel.stehule@gmail.com>) |
Ответы |
Re: a strange order by behavior
|
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: