From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | Luca Ferrari <fluca1978(at)gmail(dot)com> |
Cc: | nikhil raj <nikhilraj474(at)gmail(dot)com>, 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:57:29 |
Message-ID: | CA+bJJbzQewnD6cpyjynzuC-Jm3+kFg1dUqOxPREe_Bxyv2v0pA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Luca:
On Thu, Aug 8, 2019 at 12:33 PM Luca Ferrari <fluca1978(at)gmail(dot)com> wrote:
> 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";
It will probacly do the expected thing for him, but I think another
problem may be what does this query:
SELECT * FROM (VALUES
('0'),('1'),('a'),('A'),('á'),('à'),('b'),('B'),('ñ'),('Ñ')) order by
1;
Does on the Windows server, what he is trying to replicate. Finding a
locale which does not ignore _ as the windows one does is easy, but
replicating all the doodahs may be difficult without knowing how the
windows locale sorts all the chars ( and I'm not getting at 1a vs a1,
or _ vs a vs A).
I suspect C locale may be ok though.
Francisco Olarte.
From | Date | Subject | |
---|---|---|---|
Next Message | David Rowley | 2019-08-08 11:03:26 | Re: lead() with arrays - strange behaviour |
Previous Message | Francisco Olarte | 2019-08-08 10:51:34 | Re: Having the issue in while selecting the data and feltering in order by. |