Re: BUG #2309: Wrong string comparison

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Yury Don" <yura(at)vpcit(dot)ru>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2309: Wrong string comparison
Date: 2006-03-10 00:48:17
Message-ID: 29095.1141951697@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Yury Don" <yura(at)vpcit(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-03-10 00:50:19 Re: BUG #2310: "ALTER TYPE name OWNER TO new_owner" not working
Previous Message Chris Hodgson 2006-03-10 00:43:59 BUG #2311: Toast table chunk_id overflow