Home > mailing lists

Having the issue in while selecting the data and feltering in order by. - Mailing list pgsql-general

From	nikhil raj
Subject	Having the issue in while selecting the data and feltering in order by.
Date	August 8, 2019 09:19:40
Msg-id	CAG1ps1wvfjpv3Yjk2vVjuVoxgggnMr8ccjo_oNZ2yxipAmyvBQ@mail.gmail.com Whole thread Raw
Responses	Re: Having the issue in while selecting the data and feltering inorder by.
List	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

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

From: Tim Clarke
Date: 08 August 2019, 09:16:48
Subject: Re: Recomended front ends?

From: Luca Ferrari
Date: 08 August 2019, 10:32:31
Subject: Re: Having the issue in while selecting the data and feltering inorder by.