F.69. tsvector2

F.69.1. tsvector2 specific functions
F.69.2. Common functions that could be safely used on both types

Extended tsvector type for LightDB. It was implemented to provide better compression and to remove 1MB size limitation of original tsvector type.

It could be used as transparent replacement of original tsvector and supports all its functions, operators and index types. Functions that contain tsvector in their names have been changed to tsvector2. Full list of these functions specified below.

Refer to LightDB documentation to get details about tsvector. They can be also applied to tsvector2.

F.69.1. tsvector2 specific functions

  • to_tsvector2 (from text, json, jsonb types)

  • array_to_tsvector2

  • tsvector2_to_array

  • tsvector2_stat (should be used instead of ts_stat)

  • jsonb_to_tsvector2

  • json_to_tsvector2

  • tsvector2_update_trigger

  • tsvector2_update_trigger_column

F.69.2. Common functions that could be safely used on both types

  • strip

  • unnest

  • length

  • setweight

  • ts_rank

  • ts_rank_cd

  • ts_delete

  • ts_filter