Skip site navigation (1) Skip section navigation (2)

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 (view raw, whole thread or download thread mbox)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group