Skip site navigation (1) Skip section navigation (2)

Re: bug in string comparison

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: kopljan(at)beotel(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: bug in string comparison
Date: 2010-02-27 01:33:23
Message-ID: 9613.1267234403@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"kopljan" <kopljan(at)beotel(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Oleg SerovDate: 2010-02-27 14:13:54
Subject: Re: Diffrent column ordering after dump/restore tables with INHERITS
Previous:From: kopljanDate: 2010-02-27 00:20:24
Subject: bug in string comparison

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group