1

I am using PostgreSQL 10. I have a "booktbl" table which has 4

book_name
paragraph_title
content
ts_content

ts_content column is a tsvector column. When Iexecute this query:

select
    book_name , 
    paragraph_title ts_headline(content,to_tsquery('english','happy'), 'HighlightAll=true MaxFragments=100 FragmentDelimiter=$')
from bookstbl 
where ts_content @@ (to_tsquery('happy')) ;

I got a single row as a result which has a "ts_headline" column with all highlighted text search fragments. I want to convert all these fragments to individual rows. Like this:

book    para_title1     fragment1
book    para_title2     fragment2

How can I achieve this in PostgreSQL full text search?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.