Postgres Pro
Downloads
Home   >   mailing lists

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

From peacefultraveler
Subject ORDER BY two columns gives incorrect result on second column
Date
Msg-id oocr4dsYw7_ihBGlKFenvpWGrHZSK03Stl1UM8w9zZ7vQr9ZA_g1LLQnBfbsdr4zNp09bMCYBXj9G1_DX5_NIjU3mCw2NW5eeE02HQfyUZQ=@proton.me
Whole thread Raw
Responses Re: ORDER BY two columns gives incorrect result on second column
List pgsql-bugs
Tree view
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: Bowen Shi
Date:
Subject: Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae
Next
From: "David G. Johnston"
Date:
Subject: Re: ORDER BY two columns gives incorrect result on second column