Result of ORDER-BY

Поиск
Список
Период
Сортировка
Искать
От
Good Day Books
Тема
Result of ORDER-BY
Дата
Msg-id
73605E5F6E3A432DBCC9A40A58BA781B@GDBMain
Список
Дерево обсуждения
Re: Result of ORDER-BY "Good Day Books" <goodday@gol.com>
[PostgreSQL 8.3.9]

I have a query, as follows

SELECT DISTINCT ON(category) category
FROM gdb_books
WHERE category LIKE 'Fiction%'
GROUP BY category

The (partial) result is this:
...
# Fiction - General (A)
# Fiction - General - Anthologies
# Fiction - General (B)
# Fiction - General (C)
# Fiction - General (D)
...

I would have expected '- Anthologies' to be either at the top, or at the bottom of the result.

Does anyone have an explanation why this is not so; are the special characters (parenthesis, hyphen) just ignored?  If so, is there a way to force ORDER BY to include the special characters in the sort?

Thank you for any reply.
Pat Willener
GDB Tokyo

В списке pgsql-general по дате отправления
От: John R Pierce
Дата:
От: Christophe Pettus
Дата:
Сообщение: Re: Result of ORDER-BY
FAQ