Re: PostgreSQL Mailing list public archives : search not working ... - Mailing list pgsql-www

From Imre Samu
Subject Re: PostgreSQL Mailing list public archives : search not working ...
Date
Msg-id CAJnEWwkpt6nCR8m_O3MY1JciunDnV-5YjY7bC4rgJOF72C+U0w@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Mailing list public archives : search not working ...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-www

I can confirm that this example gives different result sets depending
on the choice of sort order.  Surely that's a bug?  I have little idea
what's going on under the hood though.

I assumed that if I searched for an existing email subject[1], I would get a hit. 
And when I didn't get a hit [2]  I was very surprised and didn't understand why?
So It's strange to me.


"postgres large database backup"  <--  so this email subject exists.

[2]  if I search for  "postgres large database backup"  in  "pgsql-general"  ordered by "date"
~ 2 ( + this mail expected )

compare to
where I see - the expected mail
- 2022-11-30 18:40:23 | postgres large database backup (Atul Kumar)

regards,
  Imre

pgsql-www by date:

Previous
From: Tom Lane
Date:
Subject: Re: PostgreSQL Mailing list public archives : search not working ...
Next
From: Magnus Hagander
Date:
Subject: Re: [PATCH] Message loader: add JIS encodings