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

[Luca Ferrari <fluca1978@xxxxxxxxx>]

On Thu, Aug 8, 2019 at 11:20 AM nikhil raj <nikhilraj474@xxxxxxxxx> 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 by val COLLATE "C";