Re: [BUGS] BUG #6270: Invalid string comparison if the string contains '+' or '-' sign.

2011-10-25 Thread Tom Lane
"Evgeniy Galkin" 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'. r

[BUGS] BUG #6270: Invalid string comparison if the string contains '+' or '-' sign.

2011-10-25 Thread Evgeniy Galkin
The following bug has been logged online: Bug reference: 6270 Logged by: Evgeniy Galkin Email address: unik...@gmail.com PostgreSQL version: 9.0.4 Operating system: GNU/Linux (Ubuntu 10.10) Description:Invalid string comparison if the string contains '+' or '-' sign.