Re: [BUGS] bug in string comparison

2010-02-28 Thread Kopljan Michael
: Saturday, February 27, 2010 2:33 AM To: kopl...@beotel.net Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] bug in string comparison "kopljan" writes: > Description: bug in string comparison What this sounds like is you are using two different locale settings in the 8.2 and 8.4

Re: [BUGS] bug in string comparison

2010-02-26 Thread Tom Lane
"kopljan" writes: > Description: bug in string comparison What this sounds like is you are using two different locale settings in the 8.2 and 8.4 installations. Postgres' string comparisons follow whatever the rules of the locale are. Try "show lc_collate" to see what the setting is. In 8.2 th