BUG #2317: Wrong sorting order for (VW) - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      2317
Logged by:          TomasKlockar
Email address:      tomask@omicron.se
PostgreSQL version: 7.3.2/7.4.7
Operating system:   linux(fedora)
Description:        Wrong sorting order for (VW)
Details:

SELECT cname FROM clients ORDER BY cname;

sorts W before V and that is a mistake.

the result is

V
W
WHI
Vi
Wi
Volvo

Correct order would be to place all vV before all wW.

I think the database was initialized with UTF8 but it might have been
ISO_8859-1, however the error is easily repeatable and ill be happy to
provide a dump.

I tested this on 7.3.2 and 7.4.7 and the error was repeatable.

regards,

/Tomas