How deeply does Just Use Postgres! cover followed by operator?

Defines positional matching and demonstrates numbered distance, without detailing full-text search internals.

Followed by operator

The PostgreSQL full-text search distance operator requires one lexeme to occur a specified number of positions after another.

The PostgreSQL full-text search followed by operator requires one lexeme to occur a specified number of positions after another. Use it through to_tsquery when word order or distance matters, rather than merely requiring every term to appear. section 6.3.2

Match a three-position distance

SELECT id, name FROM omdb.movies WHERE lexemes @@ to_tsquery('return <3> king'); This query returns The Lord of the Rings: The Return of the King, matching “king” at the requested distance after “return.” The adjacent <-> form is also available for followed-by matching. section 6.3.2

How Just Use Postgres! covers it

liveBook manning.com

Read Just Use Postgres! on liveBook Get the book at manning.com

Related concepts

cosine distanceincludes · Cosine distance is a measure of dissimilarity between nonzero vectors based on their angular separation, commonly defined as one minus cosine similarity.
pgvectorused by · pgvector is a PostgreSQL extension that adds vector data types, similarity operations, and indexes for storing and searching vector data.
to_tsqueryused by · to_tsquery is a PostgreSQL function that parses text into a tsquery value using PostgreSQL full-text search syntax and normalization rules.

This explainer was generated by Manning's knowledge graph from the text of Just Use Postgres!. The section links point to the parts of the book it draws on.