Replaces occurrences of target with substitute within the query.
ts_rewrite ( query tsquery, target tsquery, substitute tsquery ) → tsqueryReplaces occurrences of
target with substitute within the query. See Section 12.4.2.1 for details.ts_rewrite('a & b'::tsquery, 'a'::tsquery, 'foo|bar'::tsquery) → 'b' & ( 'foo' | 'bar' )ts_rewrite ( query tsquery, select text ) → tsqueryReplaces 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.SELECT ts_rewrite('a & b'::tsquery, 'SELECT t,s FROM aliases') → 'b' & ( 'foo' | 'bar' )Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source