Hacker News new | ask | show | jobs
by fatbird 3551 days ago
IIRC, I stored the plain text too because the engine can return contextually marked up plaintext after finding it in the ts_vector.
1 comments

You're right, PostgreSQL needs the plain text to highlight it with ts_headline. It's similar to Elasticsearch keeping the original document in the _source attribute. Thanks!