pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedORDER BY DESC / ASC
3+ messages / 3 participants
[nested] [flat]
* ORDER BY DESC / ASC
@ 2021-03-01 17:52 Анастасия Лагута <natriksx@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Анастасия Лагута @ 2021-03-01 17:52 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
There is an issue found while using ORDER BY DESC / ASC, where letter 'w'
is before letter 'v'. Should it be that way? Because even having a look at
the ASCII table, everything should be vice versa.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ORDER BY DESC / ASC
@ 2021-03-01 21:58 Tom Lane <tgl@sss.pgh.pa.us>
parent: Анастасия Лагута <natriksx@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2021-03-01 21:58 UTC (permalink / raw)
To: Анастасия Лагута <natriksx@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
=?UTF-8?B?0JDQvdCw0YHRgtCw0YHQuNGPINCb0LDQs9GD0YLQsA==?= <natriksx@gmail.com> writes:
> There is an issue found while using ORDER BY DESC / ASC, where letter 'w'
> is before letter 'v'. Should it be that way?
Depends on what LC_COLLATE setting you're using. I think some languages
do sort that way, at least in some contexts.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: ORDER BY DESC / ASC
@ 2021-03-02 09:00 hubert depesz lubaczewski <depesz@depesz.com>
parent: Анастасия Лагута <natriksx@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: hubert depesz lubaczewski @ 2021-03-02 09:00 UTC (permalink / raw)
To: Анастасия Лагута <natriksx@gmail.com>; +Cc: pgsql-bugs@lists.postgresql.org
On Mon, Mar 01, 2021 at 07:52:09PM +0200, Анастасия Лагута wrote:
> There is an issue found while using ORDER BY DESC / ASC, where letter 'w' is before letter 'v'. Should it be that way? Because even
> having a look at the ASCII table, everything should be vice versa.
Without knowing more we can't tell much. What is your locale? Did you
define special collate for database or columns?
Can you show us some sample data, and collate info?
Also, OS and Pg version info might be helpful.
Best regards,
depesz
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-03-02 09:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-03-01 17:52 ORDER BY DESC / ASC Анастасия Лагута <natriksx@gmail.com>
2021-03-01 21:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-03-02 09:00 ` hubert depesz lubaczewski <depesz@depesz.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox