Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table "MOVIES"(title jsonb,title_short text[]);
insert into "MOVIES" values 
  ('{"en":"title_en","de":"title_de","it":"title_it","fr":"title_fr"}','{shorttitle1,shorttitle2}')
returning jsonb_pretty(title),title_short;

CREATE TABLE

jsonb_pretty
title_short

{
    "de": "title_de",
    "en": "title_en",
    "fr": "title_fr",
    "it": "title_it"
}
{shorttitle1,shorttitle2}

INSERT 0 1

begin transaction;

alter table "MOVIES"  
add column fts  
tsvector  GENERATED ALWAYS AS ( 
to_tsvector('simple', 
coalesce(title->>'en', '') || ' ' ||  
coalesce(title->>'de', '') || ' ' ||  
coalesce(title->>'it', '') || ' ' ||  
coalesce(title->>'fr', ''))
  ) STORED;

table "MOVIES";

rollback;

BEGIN

ALTER TABLE

title
title_short
fts

{"de": "title_de", "en": "title_en", "fr": "title_fr", "it": "title_it"}
{shorttitle1,shorttitle2}
'de':4 'en':2 'fr':8 'it':6 'title':1,3,5,7

SELECT 1

ROLLBACK

create or replace function array_to_string_immutable (
    arg text[], 
    separator text default ' ',
    null_string text default null) 
returns text immutable language sql as $$
select array_to_string(arg,separator,null_string) $$;

create or replace function concat_ws_immutable (
    separator text,
    variadic arg text[]) 
returns text immutable language sql as $$
select concat_ws(separator,variadic arg) $$;

CREATE FUNCTION

CREATE FUNCTION

alter table "MOVIES"  
add column fts_short_title  
tsvector  GENERATED ALWAYS AS (  
to_tsvector('simple', 
array_to_string_immutable( title_short,' '::text)) 
 ) STORED;

table "MOVIES";

ALTER TABLE

title
title_short
fts_short_title

{"de": "title_de", "en": "title_en", "fr": "title_fr", "it": "title_it"}
{shorttitle1,shorttitle2}
'shorttitle1':1 'shorttitle2':2

SELECT 1

alter table "MOVIES"  
add column fts  
tsvector  GENERATED ALWAYS AS ( 
  to_tsvector('simple', 
              concat_ws_immutable(' ',
                        title->>'en',
                        title->>'de',
                        title->>'it',
                        title->>'fr' 
              ) 
  )
) STORED;

table "MOVIES";

ALTER TABLE

title
title_short
fts_short_title
fts

{"de": "title_de", "en": "title_en", "fr": "title_fr", "it": "title_it"}
{shorttitle1,shorttitle2}
'shorttitle1':1 'shorttitle2':2
'de':4 'en':2 'fr':8 'it':6 'title':1,3,5,7

SELECT 1