From: Hans Buschmann <buschmann@nidsa.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: AW: BUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive
Date: Sun, 7 May 2023 14:11:48 +0000
Message-ID: <0dfc8fde847c49b38f7106bbd3140fd9@nidsa.net> (raw)
In-Reply-To: <4144338.1683468308@sss.pgh.pa.us>
References: <17924-e2de0e7357152edb@postgresql.org>
<4144338.1683468308@sss.pgh.pa.us>
Hello Tom,
I don't mind the exact wording, but it should be semantically correct.
Order by date is ascending (as in SQL).
I would propose to change the wording, perhaps like Newest to oldest (or your suggestion) and make sure, that the selected order shows up in the results.
It is only part of the WebSite, so I don't fear any automation difficulties.
Hans Buschmann
________________________________
Von: Tom Lane <tgl@sss.pgh.pa.us>
Gesendet: Sonntag, 7. Mai 2023 16:05
An: Hans Buschmann
Cc: pgsql-bugs@lists.postgresql.org
Betreff: Re: BUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive
PG Bug reporting form <noreply@postgresql.org> writes:
> When changing the order of the result set from "Rank" to "Reverse Date" I
> observed that "Date" gives the results from newest to oldest while "Reverse
> Date" gives them from oldest to newest.
> This seems to me a mismatch and quite confusing.
> The semantics of Date and Reverse Date should be corrected (exchanged)
It's been like that for a decade or two, and you are the first to
complain AFAIR. Changing it at this point would doubtless add a
lot more confusion than it subtracts.
We could perhaps change to some other terms entirely, like
"Newest First" and "Oldest First", but I'm not convinced that
that's an improvement either.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: buschmann@nidsa.net, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: AW: BUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive
In-Reply-To: <0dfc8fde847c49b38f7106bbd3140fd9@nidsa.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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