pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive
2+ messages / 2 participants
[nested] [flat]
* BUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive
@ 2023-05-07 10:27 PG Bug reporting form <noreply@postgresql.org>
2023-05-07 14:05 ` Re: BUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2023-05-07 10:27 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: buschmann@nidsa.net
The following bug has been logged on the website:
Bug reference: 17924
Logged by: Hans Buschmann
Email address: buschmann@nidsa.net
PostgreSQL version: Unsupported/Unknown
Operating system: Postgres Website Mailing List search
Description:
I recently did a search on pgsql-hackers.
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)
Any thoughts?
Hans Buschmann
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive
2023-05-07 10:27 BUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive PG Bug reporting form <noreply@postgresql.org>
@ 2023-05-07 14:05 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2023-05-07 14:05 UTC (permalink / raw)
To: buschmann@nidsa.net; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-05-07 14:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-07 10:27 BUG #17924: Inverted behavior of "Date" and "Reverse Date" when searching a mailbox archive PG Bug reporting form <noreply@postgresql.org>
2023-05-07 14:05 ` Tom Lane <tgl@sss.pgh.pa.us>
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