Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 4F66792425C
	for <pgsql-sql@postgresql.org>; Wed, 16 May 2012 19:46:24 -0300 (ADT)
Received: from mail-lb0-f174.google.com ([209.85.217.174])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <comptekki@gmail.com>) id 1SUmz5-0008P3-BZ
	for pgsql-sql@postgresql.org; Wed, 16 May 2012 22:46:23 +0000
Received: by lbbgm6 with SMTP id gm6so897323lbb.19
	for <pgsql-sql@postgresql.org>; Wed, 16 May 2012 15:46:05 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	bh=MERvHHT83FYdnutWGYJCiA8RJg9aWhflFJioZQzDSCs=;
	b=dbf+r4V8ouPl3FkI1wYZVoTqDsMU91ib2dV7rYSIrBZ4K+HgFV5zhiWgljOL9w5lJf
	sq/PnjRTYw5uDecS+dH584vfpFqHnufC8izZ5+6Cx8qjX38s+GhZiM0e/wn/+yt7Q8aP
	i1ZxsiLr259abPRmC91tucWdAWngJqWHnLqc/dZpQgqz+xoZtS83j28/Q7yx7V+hx6t0
	3nOoSVYW71kufkENKu6zTzdMGl51h81mnYqO+R1inOfkoFminKPvZe5bEb4a62jJ8aYC
	RzVVW4M3a4rWOHCnAlpko8srNkfJyMZt/2sf6mx1nlWIDWcoYoCoBLZw1wFURk1Fb2zu
	NgHA==
MIME-Version: 1.0
Received: by 10.152.148.34 with SMTP id tp2mr4624470lab.47.1337208365555; Wed,
	16 May 2012 15:46:05 -0700 (PDT)
Received: by 10.112.19.137 with HTTP; Wed, 16 May 2012 15:46:05 -0700 (PDT)
In-Reply-To: <23053.1337036410@sss.pgh.pa.us>
References: 
 <CAFjCMHse4AHdTav96ifSsKaqq1Ggj43Xc=DPBfwCzZyuYKAJFQ@mail.gmail.com>
	<23053.1337036410@sss.pgh.pa.us>
Date: Wed, 16 May 2012 16:46:05 -0600
Message-ID: 
 <CAFjCMHv2ACO-+V0EDz0D5UUbVJOGbmZh6ou7+vqK3WH4Wra24Q@mail.gmail.com>
Subject: Re: order by different on mac vs linux
From: Wes James <comptekki@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=e89a8f22c7059e9fbf04c02f15e8
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201205/48
X-Sequence-Number: 36596

--e89a8f22c7059e9fbf04c02f15e8
Content-Type: text/plain; charset=ISO-8859-1

On Mon, May 14, 2012 at 5:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Wes James <comptekki@gmail.com> writes:
> > Why is there a different order on the different platforms.
>
> This is not exactly unusual.  You should first check to see if
> lc_collate is set differently in the two installations --- but even if
> it's the same, there are often platform-specific interpretations of
> the sorting rules.  (Not to mention that OS X is flat out broken when
> it comes to sorting UTF8 data ...)
>
>
I just ran these:

linux:

on linux

# SELECT CASE WHEN 'apache' > '!yada' THEN 'TRUE' ELSE 'FALSE' END FROM
pg_user;
 case
-------
 FALSE
(1 row)

# show lc_collate;
 lc_collate
-------------
 en_US.UTF-8
(1 row)

------------------------

on mac os x:

# SELECT CASE WHEN 'apache' > '!yada' THEN 'TRUE' ELSE 'FALSE' END FROM
pg_user;
 case
------
 TRUE
(1 row)

# show lc_collate;
 lc_collate
-------------
 en_US.UTF-8
(1 row)


-----------------------

Why is the linux postgres saying false with the lc_collage set the way it
is?

-wes

--e89a8f22c7059e9fbf04c02f15e8
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">On Mon, May 14, 2012 at 5:00 PM, Tom Lan=
e <span dir=3D"ltr">&lt;<a href=3D"mailto:tgl@sss.pgh.pa.us" target=3D"_bla=
nk">tgl@sss.pgh.pa.us</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_q=
uote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1e=
x">
<div class=3D"im">Wes James &lt;<a href=3D"mailto:comptekki@gmail.com">comp=
tekki@gmail.com</a>&gt; writes:<br>
&gt; Why is there a different order on the different platforms.<br>
<br>
</div>This is not exactly unusual. =A0You should first check to see if<br>
lc_collate is set differently in the two installations --- but even if<br>
it&#39;s the same, there are often platform-specific interpretations of<br>
the sorting rules. =A0(Not to mention that OS X is flat out broken when<br>
it comes to sorting UTF8 data ...)<br><br></blockquote><div><br></div><div>=
I just ran these:</div><div><br></div><div>linux:</div><div><br></div><span=
 style>on linux</span><br style><br style><span style># SELECT CASE WHEN &#=
39;apache&#39; &gt; &#39;!yada&#39; THEN &#39;TRUE&#39; ELSE &#39;FALSE&#39=
; END FROM pg_user;</span><br style>
<span style>=A0case</span><br style><span style>-------</span><br style><sp=
an style>=A0FALSE</span><br style><span style>(1 row)</span><br style><br s=
tyle><span style># show lc_collate;</span><br style><span style>=A0lc_colla=
te</span><br style>
<span style>-------------</span><br style><span style>=A0en_US.UTF-8</span>=
<br style><div><span style>(1 row)</span></div><div><br></div><div>--------=
----------------</div><div><br></div><div>on mac os x:</div><div><br></div>
<div># SELECT CASE WHEN &#39;apache&#39; &gt; &#39;!yada&#39; THEN &#39;TRU=
E&#39; ELSE &#39;FALSE&#39; END FROM pg_user;</div><div>=A0case=A0</div><di=
v>------</div><div>=A0TRUE</div><div>(1 row)</div><div><br></div><div># sho=
w lc_collate;</div>
<div>=A0lc_collate =A0</div><div>-------------</div><div>=A0en_US.UTF-8</di=
v><div>(1 row)=A0</div><div><br></div><div><br></div><div>-----------------=
------</div><div><br></div><div>Why is the linux postgres saying false with=
 the lc_collage set the way it is?</div>
<div><br></div><div>-wes</div></div>

--e89a8f22c7059e9fbf04c02f15e8--