BUG #6056: sorting issues

From: "Mike Hepworth" <michael(dot)w(dot)hepworth(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6056: sorting issues
Date: 2011-06-13 21:52:06
Message-ID: 201106132152.p5DLq6Hq046860@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 6056
Logged by: Mike Hepworth
Email address: michael(dot)w(dot)hepworth(at)gmail(dot)com
PostgreSQL version: 8.4
Operating system: Ubuntu 10.4
Description: sorting issues
Details:

Have database that is utf-8 encoding so that I can support both english,
french, and spanish. Having problems with the ordering of data.

I execute the following sql statment:

select * from (values('HALL, ANDY'),('HALLBERG, FRANK'),('HALLDEN,
DOUGLAS'),('HALL, DOUGLAS') ) x ORDER BY 1;

and get the following results

HALL, ANDY
HALLBERG, FRANK
HALLDEN, DOUGLAS
HALL, DOUGLAS

Please Help...

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Itagaki Takahiro 2011-06-14 06:44:35 Re: BUG #6056: sorting issues
Previous Message Marc Cousin 2011-06-10 14:21:59 Re: BUG #5741: syslog line length