X-POP3-Server: Host ([mail.hitechroboticsystemz.com]) 	by hitechgears.com (PostMaster POP3 Login [hrs@hitechroboticsystemz.com] [192.168.0.25]); 	Tue, 2 Aug 2011 02:32:15 +0530
Return-Path: <pgsql-general-owner+m178325@postgresql.org>
Received: from mx2.hub.org [200.46.204.254] by dr178.cyberspaceindia.com with SMTP;
   Tue, 2 Aug 2011 02:24:16 +0530
Received: from postgresql.org (mail.postgresql.org [200.46.204.86])
	by mx2.hub.org (Postfix) with ESMTP id 76AA53EAFAC6;
	Mon,  1 Aug 2011 17:54:09 -0300 (ADT)
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 7A5B2B5DBC8
	for <pgsql-general-postgresql.org@mail.postgresql.org>; Mon,  1 Aug 2011 17:53:31 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
 by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
 with ESMTP id 77792-06
 for <pgsql-general-postgresql.org@mail.postgresql.org>;
 Mon,  1 Aug 2011 20:53:24 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from svana.org (svana.org [113.212.99.187])
	by mail.postgresql.org (Postfix) with ESMTP id 70B77B5DBCB
	for <pgsql-general@postgresql.org>; Mon,  1 Aug 2011 17:53:24 -0300 (ADT)
Received: from kleptog by svana.org with local (Exim 4.72)
	(envelope-from <kleptog@svana.org>)
	id 1QnzUC-0006E0-Va; Tue, 02 Aug 2011 06:53:17 +1000
Date: Mon, 1 Aug 2011 22:53:16 +0200
From: Martijn van Oosterhout <kleptog@svana.org>
To: Johnny Edge <jedge@visafirst.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] string comparison problem
Message-ID: <20110801205316.GC21451@svana.org>
Reply-To: Martijn van Oosterhout <kleptog@svana.org>
Mail-Followup-To: Johnny Edge <jedge@visafirst.com>,
	pgsql-general@postgresql.org
References: <3CCE373A5F700D4AA37233BADC93F04C221B@bgva-s03-exch03.taxback.ess.ie>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="a8Wt8u1KmwUX3Y2C"
Content-Disposition: inline
In-Reply-To: <3CCE373A5F700D4AA37233BADC93F04C221B@bgva-s03-exch03.taxback.ess.ie>
X-PGP-Key-ID: Length=1024; ID=0x6F0B424C
X-PGP-Key-Fingerprint: 34A8 8EAC F902 8C8D CA72  DCC7 201E DB34 6F0B 424C
User-Agent: Mutt/1.5.20 (2009-06-14)
X-SA-Exim-Connect-IP: <locally generated>
X-SA-Exim-Mail-From: kleptog@svana.org
X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.623 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
 RP_MATCHES_RCVD=-0.723
X-Spam-Level: 
X-Mailing-List: pgsql-general
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org
X-Declude-Sender: pgsql-general-owner+m178325@postgresql.org [200.46.204.254]
X-Declude-Spoolname: 41064265.eml
X-Declude-RefID: str=0001.0A090205.4E371282.004E:SCGSTAT706138,ss=1,fgs=1024
X-Declude-Note: Scanned by Declude 4.10.72 "http://www.declude.com/x-note.htm"
X-Declude-Scan: Incoming Score [-5] at 02:24:28 on 02 Aug 2011
X-Declude-Tests: NOABUSE [2], FROMNOMATCH [2], HAM-INDICATOR [-8], FILTER-SUBJECT [2]
X-Country-Chain: AUSTRALIA->PANAMA->destination
X-Declude-Code: 1f
X-HELO: mx2.hub.org
X-Identity: 200.46.204.254 | mx2.hub.org | postgresql.org
X-Rcpt-To: <anisha.kaul@hitechroboticsystemz.com>
X-SmarterMail-Spam: Declude: -5
X-SmarterMail-TotalSpamWeight: -5

--a8Wt8u1KmwUX3Y2C
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Aug 01, 2011 at 10:53:16PM +0300, Johnny Edge wrote:
> Hi folks,
> =20
> I have a problem with identical versions of postgresql - 8.3.13=20
> =20
> Config files are identical. HostA is a 32 bit CentOS 5.3 install and the
> hostB is x86_64 CentOS 6.
> =20
> Difference in architecture should not be a problem - I have another 64
> bit CentOS where both queries are executed displaying identical results.

It's probably locale related. Postgres uses the same order as the
"sort" command.

Try "show lc_collate".

Hope this helps,
--=20
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> He who writes carelessly confesses thereby at the very outset that he does
> not attach much importance to his own thoughts.
   -- Arthur Schopenhauer

--a8Wt8u1KmwUX3Y2C
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iD8DBQFONxI8IB7bNG8LQkwRAsYJAKCJpM3Lofdq/9P5r34F6aaGiKe3VACfavlV
ocgjfYaEcw1A+SbXZN5VJ+g=
=8LJz
-----END PGP SIGNATURE-----

--a8Wt8u1KmwUX3Y2C--