public inbox for libc-help@sourceware.org
 help / color / mirror / Atom feed
* Is there any changes of "order by" in postgre sql with collate "en_US.utf8" between ldd (GNU libc) 2.17 and 2.34?
@ 2023-12-27  7:12 Lisa Ze
  2023-12-29 13:02 ` Florian Weimer
  0 siblings, 1 reply; 2+ messages in thread
From: Lisa Ze @ 2023-12-27  7:12 UTC (permalink / raw)
  To: libc-help

[-- Attachment #1: Type: text/plain, Size: 288 bytes --]

Hi all
I upgrade my glibc version from 2.17 to 2.34. I found that my postgre
"order by" sql has the different order list.
select * from t1 order by name asc.
Before results: glibc 2.17
A2
A_2
After results: glibc 2.34
A_2
A2

Could you help me to find the reasons for this?

Thanks!
Lisa

^ permalink raw reply	[flat|nested] 2+ messages in thread

* Re: Is there any changes of "order by" in postgre sql with collate "en_US.utf8" between ldd (GNU libc) 2.17 and 2.34?
  2023-12-27  7:12 Is there any changes of "order by" in postgre sql with collate "en_US.utf8" between ldd (GNU libc) 2.17 and 2.34? Lisa Ze
@ 2023-12-29 13:02 ` Florian Weimer
  0 siblings, 0 replies; 2+ messages in thread
From: Florian Weimer @ 2023-12-29 13:02 UTC (permalink / raw)
  To: Lisa Ze via Libc-help; +Cc: Lisa Ze

* Lisa Ze via Libc-help:

> I upgrade my glibc version from 2.17 to 2.34. I found that my postgre
> "order by" sql has the different order list.
> select * from t1 order by name asc.
> Before results: glibc 2.17
> A2
> A_2
> After results: glibc 2.34
> A_2
> A2
>
> Could you help me to find the reasons for this?

PostgreSQL has extensive documentation on this topic:

  Locale data changes
  <https://wiki.postgresql.org/wiki/Locale_data_changes>

^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2023-12-29 13:02 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2023-12-27  7:12 Is there any changes of "order by" in postgre sql with collate "en_US.utf8" between ldd (GNU libc) 2.17 and 2.34? Lisa Ze
2023-12-29 13:02 ` Florian Weimer

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).