ORDER BY two columns gives incorrect result on second column

From: peacefultraveler <peacefultraveler(at)proton(dot)me>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: ORDER BY two columns gives incorrect result on second column
Date: 2024-05-13 14:16:05
Message-ID: oocr4dsYw7_ihBGlKFenvpWGrHZSK03Stl1UM8w9zZ7vQr9ZA_g1LLQnBfbsdr4zNp09bMCYBXj9G1_DX5_NIjU3mCw2NW5eeE02HQfyUZQ=@proton.me
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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]

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2024-05-13 14:34:09 Re: ORDER BY two columns gives incorrect result on second column
Previous Message Bowen Shi 2024-05-13 03:19:16 Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae