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
