Wiki / Functions

Displays, in an abbreviated form, the match(es) for the query in the document, which must be raw text not a tsvector. Words in the document are normalized according to the specified or default configuration before matching to the query. Use of this function is discussed in Section 12.3.4, which also describes the available options.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

group

textsearch

group label

文本搜索函数和操作符

lang

en

layout

table-new

pages

functions-textsearch.html

prose only

false

ts_headline ( [config regconfig, ] document text, query tsquery [, options text] ) → text → text

ts_headline ( [config regconfig, ] document json, query tsquery [, options text] ) → text → text

ts_headline ( [config regconfig, ] document jsonb, query tsquery [, options text] ) → text → text

{"inputs":[{"file":"functions-textsearch.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"2383d74fd6eee4b71e1b97dec9754623081103120b67a9793f8deac5fff77727","version":"18.7"},{"file":"functions-textsearch.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"d8d1661c6d67bb109c5266be16236950471c11d91181aafa96e9055792c4fa78","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}