Re: String Comparision Weirdness - Mailing list pgsql-bugs

From Tobias Brox
Subject Re: String Comparision Weirdness
Date
Msg-id 20050926191125.GA5679@tobias.lan
Whole thread Raw
In response to Re: String Comparision Weirdness  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-bugs
[Stephan Szabo - Mon at 06:07:48AM -0700]
> It's more likely to be the locale in use.  For example, on my machine,
> given a file with -1 and 0.
(...)
> LANG="en_US" sort file
> 0
> -1

Hah, those Americans don't even know how to count ;-)

I find this weird, but it's clearly not a problem with postgresql at least.
We should obviously check up the locale and stick to "C" on the servers.

Thanks for the effort.

--
Notice of Confidentiality: This email is sent unencrypted over the network,
and may be stored on several email servers; it can be read by third parties
as easy as a postcard.  Do not rely on email for confidential information.

pgsql-bugs by date:

Previous
From: "Michael Kappler"
Date:
Subject: BUG #1907: problem with function return as integer[]
Next
From: Jim.Gray@Bull.com
Date:
Subject: Re: BUG #1862: ECPG Connect, host variable trailing blanks