Skip to content

Glossary: PostgreSQL Beyond the Basics

@@ (text search match operator)

Also written: @@

The operator that asks whether a tsvector matches a tsquery. For example, `search @@ websearch_to_tsquery('english','chipped mug')` finds the matching reviews.

Where the book teaches it

Related terms

tsvector, tsquerywebsearch_to_tsquery()