ts_rewrite

Replaces occurrences of target with substitute within the query. See Section 12.4.2.1 for details.

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

Reading PG 18·Select a recorded version

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

group: textsearch
group label: 文本搜索函数和操作符
lang: en
layout: table-new
pages: functions-textsearch.html
prose only: false

Definition PG 18

Replaces occurrences of target with substitute within the query. See Section 12.4.2.1 for details.

Signatures and overloads

ts_rewrite ( query tsquery, target tsquery, substitute tsquery ) → tsquery → tsquery

Replaces occurrences of target with substitute within the query. See Section 12.4.2.1 for details.

ts_rewrite ( query tsquery, select text ) → tsquery → tsquery

Replaces portions of the query according to target(s) and substitute(s) obtained by executing a SELECT command. See Section 12.4.2.1 for details.

Compare versions

Complete source facts

documentation revision

{"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"}

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:9cfb450c09e42c3acbc67c669998518219c34556097c2747852fa9d2b81b7dfb

Text language: en · wiki-repair-20261023:9cfb450c09e42c3acbc67c669998518219c34556097c2747852fa9d2b81b7dfb