Functions / Text Search Functions And Operators

plainto_tsquery

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

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

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

Converts text to a tsquery, normalizing words according to the specified or default configuration. Any punctuation in the string is ignored (it does not determine query operators). The resulting query matches documents containing all non-stopwords in the text.

plainto_tsquery('english', 'The Fat Rats') → 'fat' & 'rat'

Version history 2

12 → 13 changed
8.2 → 8.3 added

Definition snapshot: b7bd9cda · English manual source