Re: bug in string comparison

Yes, Tom, that is problem! Thanks a lot!

Michael Kopljan, Main developer
Development sector
Info Technologies DOO
Narodnih Heroja 7
11000 Beograd, Srbija
Tel: +381 (0) 62 270 834
http://www.navigator-info.com/

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Saturday, February 27, 2010 2:33 AM
To: kopljan(at)beotel(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] bug in string comparison

"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

__________ Information from ESET Smart Security, version of virus signature
database 4902 (20100228) __________

The message was checked by ESET Smart Security.

http://www.eset.com