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
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
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
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