[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 pos
On Mon, 26 Sep 2005, Tobias Brox wrote:
> We had major problems after migrating the DB to a more powerful server; we
> managed to locate the problem to a type conversion bug in our software.
> Never the less, this thing puzzles us a lot:
>
> NBTEST2=# select '-1'>'0';
> ?column?
> --
> t
[Tobias Brox - Mon at 12:17:33PM +0200]
> At all servers we tested, strcmp("-1","0") returned
> negative - at some -3 and at others -1, and not related to postgresql.
Ehr, uncorrelated to the result of the evaluation of '-1'>'0' on postgresql,
I mean.
--
Notice of Confidentiality: This email is
We had major problems after migrating the DB to a more powerful server; we
managed to locate the problem to a type conversion bug in our software.
Never the less, this thing puzzles us a lot:
NBTEST2=# select '-1'>'0';
?column?
--
t
(1 row)
We've tried this query on several servers wit
