SQL · Regular expressions and text search

ts_rank()

Ranks documents against a full-text query. PostgreSQL.

sqlRunnable example sql course

Syntax

ts_rank(vector, query)

Example

Open in the lab

-- PostgreSQL
-- SELECT ts_rank(to_tsvector('english', 'css layout'), to_tsquery('english', 'css'));

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.