Re: Per-column collation, work in progress

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема Re: Per-column collation, work in progress
Дата
Msg-id AANLkTi=zza7phKqTRruB-Ju0z0_1oA=uVH3hq+hq+s2W@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Per-column collation, work in progress  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: Per-column collation, work in progress
Re: Per-column collation, work in progress
Список pgsql-hackers
Дерево обсуждения 
On Thu, Sep 23, 2010 at 5:12 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> 3. postgres=# select to_char(current_date,'tmday') collate "cs_CZ.utf8";
>  to_char
> ──────────
>  thursday -- bad result
> (1 row)

COLLATE means "collation" rather than "locale", no?

> 5.
> postgres=# create table xy(a text, b text collate "cs_CZ");
> ERROR:  collation "cs_CZ" for current database encoding "UTF8" does not exist
> can be there some more friendly message or hint ?

I hope Postgres automatically detects the omitted encoding
because it knows the database encoding is UTF8.

--
Itagaki Takahiro

В списке pgsql-hackers по дате отправления: