Hi, all.
I observed wrong sorted results on a SELECT query with COLLATE clause.
test=# SELECT * FROM FOOBAR ORDER BY all_alpha COLLATE "en_US";
all_alpha
-----------
A
b
B
z
Z
a
(6 rows)
Related ticket is here.
https://sourceforge.net/p/postgres-xc/bugs/458/
Please refer the ticket for more details including instructions to reproduce.
Regards.
|
