Re: Sorting when "*" is the initial character

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Sorting when "*" is the initial character
Дата
Msg-id 20050207154448.J2309@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Sorting when "*" is the initial character  ("Berend Tober" <btober@seaworthysys.com>)
Список pgsql-general
On Mon, 7 Feb 2005, Berend Tober wrote:

> I encountered what looks like unusually sorting behavior, and I'm wondering if
> anyone can tell me if this is supposted to happen (and then if so, why) or if
> this is a bug:

If you ran initdb with a locale such as en_US, a result like what you got
is expected.  AFAIR, the collation rules for the locale are defined to not
use symbols and spaces in the first pass comparison so '110' < '*115' <
'120'.

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

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: [SECURITY] New sets of PostgreSQL RPMS are available for download
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: Creating an index-type for LIKE '%value%'