Re: order by different on mac vs linux
| От | Wes James |
|---|---|
| Тема | Re: order by different on mac vs linux |
| Дата | |
| Msg-id | CAFjCMHv2ACO-+V0EDz0D5UUbVJOGbmZh6ou7+vqK3WH4Wra24Q@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
|
| Список | pgsql-sql |
On Mon, May 14, 2012 at 5:00 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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
Wes James <comptekki@gmail.com> writes:This is not exactly unusual. You should first check to see if
> Why is there a different order on the different platforms.
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:
# 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
В списке pgsql-sql по дате отправления: