Re: bug in string comparison - Mailing list pgsql-bugs

From Tom Lane
Subject Re: bug in string comparison
Date
Msg-id 9613.1267234403@sss.pgh.pa.us
Whole thread Raw
In response to bug in string comparison  ("kopljan" <kopljan@beotel.net>)
Responses Re: bug in string comparison  ("Kopljan Michael" <kopljan@beotel.net>)
List pgsql-bugs
"kopljan" <kopljan@beotel.net> 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 the locale is determined at initdb time, but in 8.4 you can
set it when creating a database.

            regards, tom lane

pgsql-bugs by date:

Previous
From: "kopljan"
Date:
Subject: bug in string comparison
Next
From: Administrator
Date:
Subject: