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

[nikhil raj]

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
[image: 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.
[image: 10.250.200.184 - Remote Desktop Connection 2019-08-08 14.42.27.png]