Postgres Pro
Downloads
Home   >   mailing lists

Re: ORDER BY two columns gives incorrect result on second column - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: ORDER BY two columns gives incorrect result on second column
Date
Msg-id CAKFQuwa1YcfyAHYaEKk9MwNZkNdVakAVuMc46DYfbNcFw=S+Aw@mail.gmail.com
Whole thread Raw
In response to ORDER BY two columns gives incorrect result on second column  (peacefultraveler <peacefultraveler@proton.me>)
List pgsql-bugs
Tree view
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


Attachment

pgsql-bugs by date:

Previous
From: peacefultraveler
Date:
Subject: ORDER BY two columns gives incorrect result on second column
Next
From: Melanie Plageman
Date:
Subject: Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae