Re: Sorting problem

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: Sorting problem
Дата
Msg-id 20040716120950.J75128@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Sorting problem  (ruggero.maria.rossi@libero.it (Ruggero))
Список pgsql-sql
On Mon, 12 Jul 2004, Ruggero wrote:

> Hi all,
> I have a problem sorting varchar fields.
> I will explain the problem with a simple example:
>
> this query
>    select '##10' as sortfield
>    union
>    select '###1' as sortfield
>    order by sortfield
> produces this correct output:
>    '###1'
>    '##10'
>
> but this one
>
>   select '##10############--------####79909999' as sortfield
>   union
>   select '###1############--------####79909999' as sortfield
>   order by sortfield
> produces this wrong output:
>    '##10############--------####79909999'
>    '###1############--------####79909999'
>
> I'm using postgresql 7.4.3 on Suse Linux 9.1.
> I created my db using: initdb --pgdata=../data/ --encoding=LATIN1
> --lc-collate=it_IT --lc-ctype=it_IT
>
> Any suggestion?

it_IT looks like it's sorting based on the strings with the symbols
removed.  I get similar behavior on my system using the unix sort command
with it_IT.  This looks like it's a mismatch between what you want and the
collation you've provided.



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

Предыдущее
От: "Sarah Tanembaum"
Дата:
Сообщение: Re: [PHP] Secure DB Systems - How to
Следующее
От: martian.bob@gmail.com (Bob Arens)
Дата:
Сообщение: Query plan discrepancies