Functions / Text Search Functions And Operators
Converts text to a tsvector, normalizing words according to the specified or default configuration.
Reading PG 18current·documented in 20 of 27 versions, 8.3 to 20
to_tsvector ( [ config regconfig, ] document text ) → tsvectorConverts text to a
tsvector, normalizing words according to the specified or default configuration. Position information is included in the result.to_tsvector('english', 'The Fat Rats') → 'fat':2 'rat':3to_tsvector ( [ config regconfig, ] document json ) → tsvectorConverts each string value in the JSON document to a
tsvector, normalizing words according to the specified or default configuration. The results are then concatenated in document order to produce the output. Position information is generated as though one stopword exists between each pair of string values. (Beware that “document order” of the fields of a JSON object is implementation-dependent when the input is jsonb; observe the difference in the examples.)to_tsvector('english', '{"aa": "The Fat Rats", "b": "dog"}'::json) → 'dog':5 'fat':2 'rat':3to_tsvector('english', '{"aa": "The Fat Rats", "b": "dog"}'::jsonb) → 'dog':1 'fat':4 'rat':5to_tsvector ( [ config regconfig, ] document jsonb ) → tsvectorConverts each string value in the JSON document to a
tsvector, normalizing words according to the specified or default configuration. The results are then concatenated in document order to produce the output. Position information is generated as though one stopword exists between each pair of string values. (Beware that “document order” of the fields of a JSON object is implementation-dependent when the input is jsonb; observe the difference in the examples.)to_tsvector('english', '{"aa": "The Fat Rats", "b": "dog"}'::json) → 'dog':5 'fat':2 'rat':3to_tsvector('english', '{"aa": "The Fat Rats", "b": "dog"}'::jsonb) → 'dog':1 'fat':4 'rat':5Definition snapshot: b7bd9cda · English manual source