Re: Order By ignoring "-" character

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Order By ignoring "-" character
Дата
Msg-id 20030607152132.GB8873@wolff.to
обсуждение исходный текст
Ответ на Order By ignoring "-" character  (Dave Wood <postgresql_question@attbi.com>)
Список pgsql-general
On Thu, Jun 05, 2003 at 11:43:08 -0400,
  Dave Wood <postgresql_question@attbi.com> wrote:
> I'm having a problem where the ORDER BY clause is not performing as I
> would expect.  I created a small set of test data:
>
> If this isn't considered a bug, then could somebody please enlighten me
> as to the proper use of ORDER BY?  In other words, how do I get postgres
> to order by using a sort typical of every text sort I've ever seen?
> Once that takes case into consideration and doesn't pick and choose
> which characters it will use for the sort.

It is a locale issue. Order by sorts by the locale ordering. I believe
the fix for this thi requires an initdb, specifying C for the locale.

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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Order By ignoring "-" character
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Order By ignoring "-" character