Having the issue in while selecting the data and feltering in order by.

Поиск
Список
Период
Сортировка
От nikhil raj
Тема Having the issue in while selecting the data and feltering in order by.
Дата
Msg-id CAG1ps1wvfjpv3Yjk2vVjuVoxgggnMr8ccjo_oNZ2yxipAmyvBQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Having the issue in while selecting the data and feltering inorder by.  (Luca Ferrari <fluca1978@gmail.com>)
Список pgsql-general
Hi ALL,

I have recently migrated to windows postgres server to linux postgres server.

while i run this query in windows PG server
SELECT *
FROM (VALUES ('a'), ('___b1'), ('_a1'),('a2'),('a3'),('a5'), ('a2')) t (val) order by val

I am getting the out put in this sort order
10.250.200.184 - Remote Desktop Connection 2019-08-08 14.46.46.png

Same when i run this in linux machine i am getting this out in  different sort order on the same query.
10.250.200.184 - Remote Desktop Connection 2019-08-08 14.42.27.png


Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Tim Clarke
Дата:
Сообщение: Re: Recomended front ends?
Следующее
От: Luca Ferrari
Дата:
Сообщение: Re: Having the issue in while selecting the data and feltering inorder by.