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

2019-08-08 Thread Francisco Olarte
Luca: On Thu, Aug 8, 2019 at 12:33 PM Luca Ferrari wrote: > On Thu, Aug 8, 2019 at 11:20 AM nikhil raj wrote: > > Same when i run this in linux machine i am getting this out in different > > sort order on the same query. > A collation problem? > What does this query do? > SELECT * > FROM (VALU

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

2019-08-08 Thread Francisco Olarte
Nikhil ( or is it Raj? ): On Thu, Aug 8, 2019 at 11:47 AM nikhil raj wrote: > Here are the detailes. > Windows : Zapped image showing windows locale "English-united-states.1252" > linux : Zapped image showing Linux locale "En-us.utf-8" > both are in same version 11.3 > How can i get the sorting o

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

2019-08-08 Thread Luca Ferrari
On Thu, Aug 8, 2019 at 11:20 AM nikhil raj wrote: > Same when i run this in linux machine i am getting this out in different > sort order on the same query. A collation problem? What does this query do? SELECT * FROM (VALUES ('a'), ('___b1'), ('_a1'),('a2'),('a3'),('a5'), ('a2')) t (val) order

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

2019-08-08 Thread 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