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

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: nikhil raj <nikhilraj474(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Having the issue in while selecting the data and feltering in order by.
Date: 2019-08-08 10:32:31
Message-ID: CAKoxK+77dmxWLzXLg=N=JLvg56PpK3+=ZV+pEuDQa-7XwcgrVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 8, 2019 at 11:20 AM nikhil raj <nikhilraj474(at)gmail(dot)com> 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";

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2019-08-08 10:51:34 Re: Having the issue in while selecting the data and feltering in order by.
Previous Message nikhil raj 2019-08-08 09:19:40 Having the issue in while selecting the data and feltering in order by.