Re: LC_COLLATE=es_MX in PgSQL 7.3.2

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: LC_COLLATE=es_MX in PgSQL 7.3.2
Дата
Msg-id Pine.LNX.4.44.0306161358290.2751-100000@peter.localdomain
обсуждение исходный текст
Ответ на Re: LC_COLLATE=es_MX in PgSQL 7.3.2  ("Octavio Alvarez" <alvarezp@octavio.ods.org>)
Список pgsql-general
Octavio Alvarez writes:

> No accents here. I would have expected:
>    p   |   m
> -------+-------
>  OCTAV | ALVAA
>  octav | alvar
>  OCTAV | ALVAZ
>  OCTIa | ALVAa
>  octia | alvra
>  OCTIb | ALVZa
>  OCTIb | ALVZa
>  OCTIc | ALVAa
>  octic | alvra
>  OCTVI | ALVAa
>  octvi | alvra
>  OCTVI | ALVZa
> (12 rows)

That's not the way it works.  First it sorts by p, then by m -- there is
no cross-column magic.  Maybe for your application you will be happier if
you sort by lower(p), lower(m).

--
Peter Eisentraut   peter_e@gmx.net


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