BUG #6244: Ordering Problem - Mailing list pgsql-bugs

From Murilo Lobato
Subject BUG #6244: Ordering Problem
Date
Msg-id 201110071331.p97DVbed076411@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #6244: Ordering Problem  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-bugs
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.

pgsql-bugs by date:

Previous
From: Craig Ringer
Date:
Subject: Re: BUG #6233: pg_dump hangs with Access Violation C0000005
Next
From: Merlin Moncure
Date:
Subject: Re: BUG #6244: Ordering Problem