News for hackers. Stuff that matters.

A comment on PostgreSQL 9.6 Released. Parent comment

Re:PostgreSQL 9.6 Released by fatbird on Thursday September 29, 2016 @11:15AM (#12605907)
IIRC, I stored the plain text too because the engine can return contextually marked up plaintext after finding it in the ts_vector.
[ Parent | on HN ]
Re:PostgreSQL 9.6 Released by ngrilly on Thursday September 29, 2016 @11:40AM (#12606112)
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!
[ Parent | on HN ]