Re: [BUGS] BUG #6056: sorting issues

2011-06-14 Thread Itagaki Takahiro
On Tue, Jun 14, 2011 at 21:28, Michael Hepworth wrote: > Thanks for the response.  I have created a database with lc_collate = > en_US.utf8.  This doesn't seem to work.  I does however allow me to sort my > non english names correctly.  If I drop the database and recreate it with > lc_collate = C

Re: [BUGS] BUG #6056: sorting issues

2011-06-14 Thread hubert depesz lubaczewski
On Mon, Jun 13, 2011 at 09:52:06PM +, Mike Hepworth wrote: > 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

Re: [BUGS] BUG #6056: sorting issues

2011-06-13 Thread Itagaki Takahiro
On Tue, Jun 14, 2011 at 06:52, Mike Hepworth wrote: > Bug reference:      6056 > Logged by:          Mike Hepworth > Email address:      michael.w.hepwo...@gmail.com > PostgreSQL version: 8.4 > Operating system:   Ubuntu 10.4 > Description:        sorting issues > Details: > > Have database that i

[BUGS] BUG #6056: sorting issues

2011-06-13 Thread Mike Hepworth
The following bug has been logged online: Bug reference: 6056 Logged by: Mike Hepworth Email address: michael.w.hepwo...@gmail.com PostgreSQL version: 8.4 Operating system: Ubuntu 10.4 Description:sorting issues Details: Have database that is utf-8 encoding so that