Re: Order By ignoring "-" character

От

Bruno Wolff III

Тема

Дата

9 июня 2003 г. в 06:25:10

Msg-id

20030607152132.GB8873@wolff.to

обсуждение

Ответ на

Order By ignoring "-" character (Dave Wood)

Список

pgsql-general

Дерево обсуждения

Order By ignoring "-" character Dave Wood <postgresql_question@attbi.com> 7 июня 2003 г. в 07:54:11

Re: Order By ignoring "-" character Tom Lane <tgl@sss.pgh.pa.us> 9 июня 2003 г. в 06:31:01

Re: Order By ignoring "-" character Stephan Szabo <sszabo@megazone23.bigpanda.com> 9 июня 2003 г. в 06:24:24

Re: Order By ignoring "-" character Bruno Wolff III <bruno@wolff.to> 9 июня 2003 г. в 06:25:10

Re: Order By ignoring "-" character Peter Eisentraut <peter_e@gmx.net> 9 июня 2003 г. в 05:57:02

On Thu, Jun 05, 2003 at 11:43:08 -0400,
  Dave Wood  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

Дата: 9 июня 2003 г. в 06:24:24

Сообщение: Re: Order By ignoring "-" character

Следующее

От: Tom Lane

Дата: 9 июня 2003 г. в 06:31:01

Сообщение: Re: Order By ignoring "-" character