undefined | Better HN

0 pointsngrilly9y ago0 comments

Did you store the plain text of each PDF in PostgreSQL or just the ts_vector resulting from the plain text?

0 comments

IIRC, I stored the plain text too because the engine can return contextually marked up plaintext after finding it in the ts_vector.

ngrillyOP9y ago

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!

j / k navigate · click thread line to collapse

0 pointsngrilly9y ago0 comments

Did you store the plain text of each PDF in PostgreSQL or just the ts_vector resulting from the plain text?

0 comments

fatbird9y ago

IIRC, I stored the plain text too because the engine can return contextually marked up plaintext after finding it in the ts_vector.

ngrillyOP9y ago

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!

j / k navigate · click thread line to collapse