pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ORDER 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