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  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: order by different on mac vs linux  (Wes James <comptekki@gmail.com>)
Re: order by different on mac vs linux  (Wes James <comptekki@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: syncing - between databases
Следующее
От: Tom Lane
Дата:
Сообщение: Re: order by different on mac vs linux