Re: BUG #15919: When sorting, does the result show that S > s is correct?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #15919: When sorting, does the result show that S > s is correct?
Дата
Msg-id 23071.1563545773@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #15919: When sorting, does the result show that S > s is correct?  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> postgres@[local]:5433[postgres]#select * from t order by info asc;
> +------+
> | info |
> +------+
> | s    |
> | S    |
> +------+
> (2 rows)

This is the expected behavior for en_US locale, as you can easily
confirm outside of Postgres:

$ (echo s; echo S) | LANG=en_US sort
s
S

Perhaps you are confusing it with C locale?

$ (echo s; echo S) | LANG=C sort
S
s

            regards, tom lane



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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15919: When sorting, does the result show that S > s is correct?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SELECT with COLLATE results in segfault on trunk and 12 Beta 2