Functions / Text Search Functions And Operators

websearch_to_tsquery

Converts text to a tsquery, normalizing words according to the specified or default configuration.

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

websearch_to_tsquery ( [ config regconfig, ] query text ) → tsquery

Converts text to a tsquery, normalizing words according to the specified or default configuration. Quoted word sequences are converted to phrase tests. The word “or” is understood as producing an OR operator, and a dash produces a NOT operator; other punctuation is ignored. This approximates the behavior of some common web search tools.

websearch_to_tsquery('english', '"fat rat" or cat dog') → 'fat' <-> 'rat' | 'cat' & 'dog'

Version history 2

12 → 13 changed
10 → 11 added

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