The following bug has been logged online:
Bug reference: 6244
Logged by: Murilo Lobato
Email address: murilo@perfilweb.com.br
PostgreSQL version: 9.0.3
Operating system: Centos 5.5
Description: Ordering Problem
Details:
We have a clients table, and when we run a select on the table ordering by
name we get unexpected results. The whitespaces on the string are not being
computed, as follown:
what is happening:
1 - Lucia Amaral
2 - Luci Martins
What we expecting:
1 - Luci Martins
2 - Lucia Amaral
Resuming, the whitespace is being ignored during the order.