Re: ORDER BY two columns gives incorrect result on second column

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: ORDER BY two columns gives incorrect result on second column
Дата
Msg-id CAKFQuwa1YcfyAHYaEKk9MwNZkNdVakAVuMc46DYfbNcFw=S+Aw@mail.gmail.com
обсуждение исходный текст
Ответ на ORDER BY two columns gives incorrect result on second column  (peacefultraveler <peacefultraveler@proton.me>)
Список pgsql-bugs
Дерево обсуждения
Behaving correctly for your data.

The spelling of the school name in the final row is capital M, capital I; there is no tie to break from the prior two rows where the I is lowercase.


David J.


On Monday, May 13, 2024, peacefultraveler <peacefultraveler@proton.me> wrote:
Hello,
I'm working through a tutorial that calls for a ORDER BY on two columns. The first column sorts correctly, but the second one doesn't:

image.png

This is running on Windows 11, and the version is:

image.png


Вложения

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

Предыдущее
От: peacefultraveler
Дата:
Сообщение: ORDER BY two columns gives incorrect result on second column
Следующее
От: Melanie Plageman
Дата:
Сообщение: Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae