db.l3.ai

Play

lessons

what-changed-in-19

editor

engine: not started

results

Run a query to see rows here.

check

tsvector

Full-text search does not compare raw strings. It turns text into a tsvector: a sorted list of normalised words (lexemes) with their positions. Stop words drop out and words are stemmed, so 'bridges' and 'bridge' become one lexeme.

task

Show the tsvector of the title of article 1 (english).

hints