| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | peacefultraveler <peacefultraveler(at)proton(dot)me> |
| Cc: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: ORDER BY two columns gives incorrect result on second column |
| Date: | 2024-05-13 14:34:09 |
| Message-ID: | CAKFQuwa1YcfyAHYaEKk9MwNZkNdVakAVuMc46DYfbNcFw=S+Aw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)proton(dot)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: image.png]
>
> This is running on Windows 11, and the version is:
>
> [image: image.png]
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melanie Plageman | 2024-05-13 14:42:31 | Re: relfrozenxid may disagree with row XIDs after 1ccc1e05ae |
| Previous Message | peacefultraveler | 2024-05-13 14:16:05 | ORDER BY two columns gives incorrect result on second column |