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

Re: bug in string comparison

From: "Kopljan Michael" <kopljan(at)beotel(dot)net>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: bug in string comparison
Date: 2010-02-28 18:25:41
Message-ID: 003801cab8a3$6f902c60$4eb08520$@net (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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

-----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.

In response to

pgsql-bugs by date

Next:From: Tom LaneDate: 2010-02-28 19:33:09
Subject: Re: possible bug not in open items
Previous:From: Jeff DavisDate: 2010-02-28 17:47:33
Subject: Re: possible bug not in open items

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