The following bug has been logged online: Bug reference: 2317 Logged by: TomasKlockar Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend