Full Text Search

#More detali safepal
SELECT setweight(to_tsvector('title'), 'A') ||
       setweight(to_tsvector('keyword'), 'B');
SELECT to_tsquery('keyword | title:A');
SELECT setweight(to_tsvector('title'), 'A') ||
       setweight(to_tsvector('keyword'), 'B') @@ to_tsquery('keyword | title:C');
SELECT setweight(to_tsvector('title'), 'A') @@ to_tsquery('title:A');
SELECT ts_headline('sadsad keyword sa tit dfds titleas  asd title' , to_tsquery('keyword | tit:*'), 'StartSel = <, StopSel = >')
SELECT regexp_matches(
    'foobarbequebazilbarfbonk', '(b[^b]+)(b[^b]+)', 'g');
SELECT regexp_matches(
    '123 12 1234 1', '((\d+) (\d+))+', 'g');
SELECT regexp_matches(ts_headline('sadsad keyword sa tit dfds titleas  asd title', to_tsquery('keyword | tit:*'),
                                  'StartSel = <, StopSel = >'), '<[^<>]+>', 'g');
SELECT regexp_matches(ts_headline('sadsad keyword sa tit dfds titleas  asd title', to_tsquery('keyword | tit:*'),
                                  'StartSel = <, StopSel = >'), '(<[^<>]+>)', 'g');
SELECT regexp_matches(ts_headline('sadsad keyword sa tit dfds titleas  asd title', to_tsquery('keyword | tit:*'),
                                  'StartSel = <, StopSel = >'), '[^<>]*(<[^<>]+>)[^<>]*', 'g');
SELECT unnest(regexp_matches(ts_headline('sadsad keyword sa tit dfds titleas  asd title', to_tsquery('keyword | tit:*'),
                                  'StartSel = <, StopSel = >'), '<[^<>]+>', 'g'));
SELECT array_agg(regexp_matches.*)
FROM regexp_matches(ts_headline('sadsad keyword sa tit dfds titleas  asd title', to_tsquery('keyword | tit:*'),
                                'StartSel = <, StopSel = >'), '<[^<>]+>', 'g') regexp_matches;
SELECT array_agg(unnest.e) FROM (Select unnest(regexp_matches(ts_headline('sadsad keyword sa tit dfds titleas  asd title', to_tsquery('keyword | tit:*'),
                                                        'StartSel = <, StopSel = >'), '<[^<>]+>', 'g')) as e) unnest
SELECT coalesce(array_agg(unnest.e), '{}') FROM (Select unnest(regexp_matches(ts_headline('sadsad s  asd fdfs', to_tsquery('keyword | tit:*'),
                                                                          'StartSel = <, StopSel = >'), '<[^<>]+>', 'g')) as e) unnest