order by different on mac vs linux
От | Wes James |
---|---|
Тема | order by different on mac vs linux |
Дата | |
Msg-id | CAFjCMHse4AHdTav96ifSsKaqq1Ggj43Xc=DPBfwCzZyuYKAJFQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: order by different on mac vs linux
Re: order by different on mac vs linux Re: order by different on mac vs linux |
Список | pgsql-sql |
I have postgresql 9.1.3 on a mac and on linux. On the mac the results come out: ! *`-=[];',./~@#$%^&()_+{}|:"<>?\ then \--\ On ubuntu 12.04 x64 it comes out (compiled and installed postgres from tbz2 from postgresql.org repo): \--\ then ! *`-=[];',./~@#$%^&()_+{}|:"<>?\ 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
В списке pgsql-sql по дате отправления: