Horton

Re: BUG #2309: Wrong string comparison

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Yury Don" <yura@vpcit.ru>
Cc: pgsql-bugs@postgresql.org
Date: 2006-03-10T00:48:17Z
Lists: pgsql-bugs 
"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