Help for this page

Select Code to Download


  1. or download this
    CREATE TABLE sometable (
      ...
    ...
    );
    CREATE INDEX sometable_fulltext ON sometable
      USING GIN (to_tsvector('english', keyword_search));
    
  2. or download this
       keyword_search text not null GENERATED ALWAYS AS (
         name || ' ' || COALESCE(description, '')
         || ' ' || COALESCE(tags, '')) STORED,
    
  3. or download this
    SELECT * FROM sometable
    WHERE to_tsvecor('english',keyword_search) @@ plainto_tsquery('english
    +', ?)
    ORSER BY ts_rank(to_tsvecor('english',keyword_search), plainto_tsquery
    +('english', ?))