Re: String Comparision Weirdness

From: Tobias Brox <tobias(at)nordicbet(dot)com>
To: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
Cc: Tobias Brox <tobias(at)nordicbet(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: String Comparision Weirdness
Date: 2005-09-26 19:11:25
Message-ID: 20050926191125.GA5679@tobias.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-09-26 19:55:25 Re: BUG #1907: problem with function return as integer[]
Previous Message Abel Pinto Muoz 2005-09-26 16:25:47 BUG #1911: Error in PSQLODBC.DLL using SQLTablePrivileges