Topic: search
-
Full-text search in PostgreSQL with tsvector
PostgreSQL turns text into a tsvector of normalised lexemes using a language configuration, matches it against tsquery, ranks with ts_rank and indexes it with GIN; it handles stemming and stop words but not typos or synonyms out of the box.
Machine-readable: JSON