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