dbTalk Databases Forums  

Re: [BUGS] Order by and leading spaces

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss Re: [BUGS] Order by and leading spaces in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stephan Szabo
 
Posts: n/a

Default Re: [BUGS] Order by and leading spaces - 07-06-2003 , 12:38 PM






On Sun, 6 Jul 2003, Emmanuel GUYOT - InCrEG wrote:

Quote:
I've noticed that the 7.3.3 has a strange behaviour were sorting rows
with leading spaces. It seems that leadings spaces are ignored.
Are you in "C" locale or some other locale and on what OS? Some (many?)
OS locale definitions have collation rules that ignore spaces and/or
symbols. For example, on my redhat box in en_US locale, " b" > "a".


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.