Functions / Text Search Functions And Operators

ts_stat

Executes the sqlquery, which must return a single tsvector column, and returns statistics about each distinct lexeme contained in the data.

Reading PG 18current·documented in 20 of 27 versions, 8.3 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

ts_stat ( sqlquery text [, weights text ] ) → setof record ( word text, ndoc integer, nentry integer )

Executes the sqlquery, which must return a single tsvector column, and returns statistics about each distinct lexeme contained in the data. See Section 12.4.4 for details.

ts_stat('SELECT vector FROM apod') → (foo,10,15) ...

Version history 2

12 → 13 changed
8.2 → 8.3 added

Definition snapshot: b7bd9cda · English manual source