Re: PG 14 release notes, first draft - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: PG 14 release notes, first draft
Date
Msg-id 20210511023445.GO6088@momjian.us
Whole thread Raw
In response to Re: PG 14 release notes, first draft  (Alexander Korotkov <aekorotkov@gmail.com>)
Responses Re: PG 14 release notes, first draft
List pgsql-hackers
On Mon, May 10, 2021 at 04:02:27PM +0300, Alexander Korotkov wrote:
> Hi, Bruce!
> 
> On Mon, May 10, 2021 at 9:03 AM Bruce Momjian <bruce@momjian.us> wrote:
> > I have committed the first draft of the PG 14 release notes.  You can
> > see the most current  build of them here:
> >
> >         https://momjian.us/pgsql_docs/release-14.html
> >
> > I need clarification on many items, and the document still needs its
> > items properly ordered, and markup added.  I also expect a lot of
> > feedback.
> >
> > I plan to work on completing this document this coming week in
> > preparation for beta next week.
> 
> Thank you very much for your work!
> 
> Let me provide a missing description for the items related to me.
> 
>  * Improve handling of compound words in to_tsquery() and
> websearch_to_tsquery() (Alexander Korotkov)
> Compound words are now transformed into parts connected with phrase
> search operators.  For example, to_tsquery('pg_class') becomes 'pg <->
> class' instead of 'pg & class'.  This eliminates bug of handling
> compound words connected with the phrase operator and makes the search
> of compound words more strict.

OK, what symbols trigger this change?  Underscore?  What else?  You are
saying the previous code allowed 'pg' and 'class' anywhere in the
string, while the new code requires them to be adjacent, which more
closely matches the pattern.

>  * Fix extra distance in phrase operators for quoted text in
> websearch_to_tsquery() (Alexander Korotkov)
> For example, websearch_to_tsquery('english', '"aaa: bbb"') becomes
> 'aaa <> bbb' instead of  'aaa <2> bbb'.

So colon and space were considered to be two tokens between 'aaa' and
'bbb', while is really only one because both tokens are discarded?  Is
this true of any discarded tokens, e.g. ''"aaa ?:, bbb"'?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.




pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: walreceiver that is behind doesn't quit, send replies
Next
From: Peter Smith
Date:
Subject: Re: Corrected documentation of data type for the logical replication message formats.