View Single Post

   
  #2 (permalink)  
Old 04-10-2008, 10:49 AM
Tom Lane
 
Posts: n/a
Default Re: BUG #2309: Wrong string comparison

"Yury Don" <yura@vpcit.ru> writes:
> Looks like string comparison operators ignore spaces isnside of string.


It's not wrong, it's just following the rules of the locale. You should
initdb the database with LANG=C if you want plain ASCII sorting.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote