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

[nikhil raj <nikhilraj474@xxxxxxxxx>]

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

Same when i run this in linux machine i am getting this out in  different sort order on the same query.