Result of ORDER-BY
От | Good Day Books |
---|---|
Тема | Result of ORDER-BY |
Дата | |
Msg-id | 73605E5F6E3A432DBCC9A40A58BA781B@GDBMain обсуждение исходный текст |
Ответы |
Re: Result of ORDER-BY
Re: Result of ORDER-BY |
Список | pgsql-general |
[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 по дате отправления: