What is the limit for weight parameters in Full Text Search

Question

I can add 4 weights but the moment I add the fifth got an error

update pois 
set tsearch = setweight(to_tsvector(name), 'A') ||
              setweight(to_tsvector(coalesce(state_name, '')), 'B') ||
              setweight(to_tsvector(coalesce(city_name)), 'C') ||
              setweight(to_tsvector(coalesce(address, '')), 'D') ||   -- 4 weight work ok
              setweight(to_tsvector(coalesce(sector_name, '')), 'E'); -- add this and got error

ERROR: unrecognized weight: 69
SQL state: XX000

score 4 · Accepted Answer · answered May 21 '20 at 20:49

4

documentation says you can only have 4:

setweight returns a copy of the input vector in which every position has been labeled with the given weight, either A, B, C, or D. (D is the default for new vectors and as such is not displayed on output.) These labels are retained when vectors are concatenated, allowing words from different parts of a document to be weighted differently by ranking functions.

Note that weight labels apply to positions, not lexemes. If the input vector has been stripped of positions then setweight does nothing.

answered May 21 '20 at 20:49

pifor

7,419
2
8
16

The first part answer my question. But I don't understand the note. Can you elaborate? – Juan Carlos Oropeza May 22 '20 at 04:59
No sorry I can't. If you need more explanation I suggest asking your question to https://www.postgresql.org/list/pgsql-general/ – pifor May 22 '20 at 07:05

What is the limit for weight parameters in Full Text Search

1 Answers1