order by different on mac vs linux

From: Wes James <comptekki(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: order by different on mac vs linux
Date: 2012-05-14 22:42:05
Message-ID: CAFjCMHse4AHdTav96ifSsKaqq1Ggj43Xc=DPBfwCzZyuYKAJFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have postgresql 9.1.3 on a mac and on linux.

On the mac the results come out:

! *`-=[];',./~(at)#$%^&()_+{}|:"<>?\

then

\--\

On ubuntu 12.04 x64 it comes out (compiled and installed postgres from
tbz2 from postgresql.org repo):

\--\

then

! *`-=[];',./~(at)#$%^&()_+{}|:"<>?\

Why is there a different order on the different platforms. I even
copied the data folder on the mac to the linux box instead of doing
pg_dump and then \i pg.sql file on Linux to move the data and the
order is still different like this.

Any idea why? the ! line should come before the \ line, lexically. !
is char 33 and \ is char 92.

This is done with

select * from table order by field;

on both systems and "field" is character varying on both systems.

Thanks,

Wes

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2012-05-14 23:00:10 Re: order by different on mac vs linux
Previous Message Devrim GÜNDÜZ 2012-05-14 12:04:00 Re: syncing - between databases