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	May 13 17:16:05
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

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:

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

From: Bowen Shi
Date: 13 May, 06:19:16
Subject: Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae

From: "David G. Johnston"
Date: 13 May, 17:34:09
Subject: Re: ORDER BY two columns gives incorrect result on second column