Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6270: Invalid string comparison if the string contains '+' or '-' sign. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6270: Invalid string comparison if the string contains '+' or '-' sign.
Date
Msg-id 25980.1319566408@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6270: Invalid string comparison if the string contains '+' or '-' sign.  ("Evgeniy Galkin" <unikoid@gmail.com>)
List pgsql-bugs
Tree view 
"Evgeniy Galkin" <unikoid@gmail.com> writes:
> I'm trying to compare two strings which are starting with '+' and '-' signs.
> And there is some strange behaviour.

This is fairly standard if you're using a non-C locale.  Try creating a
fresh database with LC_COLLATE and LC_CTYPE set to 'C'.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Evgeniy Galkin"
Date:
Subject: BUG #6270: Invalid string comparison if the string contains '+' or '-' sign.
Next
From: bricklen
Date:
Subject: Re: auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)