Example trigger to update doc into tsvestor

postgresql trigger.sql

drop table if exists searchable_table_test;

create table if not exists searchable_table_test (
    id serial primary key not null,
    data jsonb not null,
    searchable tsvector null
);


create or replace function make_doc_searchable() returns trigger as $make_doc_searchable$
begin
    NEW.searchable := to_tsvector(NEW.data ->> 'Name') ||
                      to_tsvector(NEW.data ->> 'Address' ||
                      to_tsvector(NEW.data ->> 'Tags'));

    return NEW;
end;
$make_doc_searchable$ language plpgsql;

drop trigger if exists searchable_doc_trigger on searchable_table_test;
create trigger searchable_doc_trigger before insert or update on searchable_table_test
    for each row execute procedure make_doc_searchable();


insert into searchable_table_test (data) values ('{"Name": "Phillip Haydon", "Address": "Somewhere in Singapore", "Tags": ["One", "Two", "Three"]}');

select * from searchable_table_test;

update searchable_table_test set data = '{"Name": "Prentice Porter", "Address": "Somewhere in Singapore", "Tags": ["One", "Two", "Three"]}' where id = 1;

select * from searchable_table_test;