Postgres Pro
Downloads
Home   >   mailing lists

Re: Empty string in lexeme for tsvector - Mailing list pgsql-hackers

From Jean-Christophe Arnu
Subject Re: Empty string in lexeme for tsvector
Date
Msg-id CAHZmTm1MoTXXNN7yRwe+ADGPnyNS5XB2YTJyFOcCokXVKxfVjw@mail.gmail.com
Whole thread Raw
In response to Re: Empty string in lexeme for tsvector  (Jean-Christophe Arnu <jcarnu@gmail.com>)
Responses Re: Empty string in lexeme for tsvector
List pgsql-hackers
Tree view


Le dim. 26 sept. 2021 à 22:41, Jean-Christophe Arnu <jcarnu@gmail.com> a écrit :


Le dim. 26 sept. 2021 à 15:55, Artur Zakirov <zaartur@gmail.com> a écrit :
Nice catch! The patch looks good to me.
Can you also add a more general test case:

=# SELECT $$'' '1' '2'$$::tsvector;
ERROR:  syntax error in tsvector: "'' '1' '2'"
LINE 1: SELECT $$'' '1' '2'$$::tsvector;


Thank you, Artur for spotting this test.
It is now included into this patch.
 


Two more things :

  * I updated the documentation for array_to_tsvector(), ts_delete() and setweight() functions (so here's a new patch);
  * I should mention François Ferry from Logilab who first reported the backup/restore problem that led to this patch.

I think this should be ok, now the doc is up to date.

Kind regards.
--
Jean-Christophe Arnu
Attachment

pgsql-hackers by date:

Previous
From: Greg Nancarrow
Date:
Subject: Re: Added schema level support for publication.
Next
From: Amit Kapila
Date:
Subject: Re: Column Filtering in Logical Replication