Functions / Text Search Functions And Operators

array_to_tsvector

Converts an array of text strings to a tsvector.

Reading PG 18current·documented in 12 of 27 versions, 9.6 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

array_to_tsvector ( text[] ) → tsvector

Converts an array of text strings to a tsvector. The given strings are used as lexemes as-is, without further processing. Array elements must not be empty strings or NULL.

array_to_tsvector('{fat,cat,rat}'::text[]) → 'cat' 'fat' 'rat'

Version history 3

14 → 15 changed
12 → 13 changed
9.5 → 9.6 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source