sql
DECLARE
  slash_position INT;
  value int;
  entry_id int;
BEGIN
  -- Encontra a posição da última ocorrência do caractere '/'
  slash_position := strpos(reverse(new.short_url), '/');
  
  -- Extrai o valor após a última ocorrência do caractere '/'
  value := reverse(substring(reverse(new.short_url) from 1 for slash_position - 1));

  select id 
  from url_data 
  into entry_id
  where slug = value;

  update public.report_data
  set id = entry_id
  where id = new.id;

  RETURN new;
END;

erro :

"No operator matches the given name and argument types. You might need to add explicit type casts."

Do you have RLS involved on report_data table if this is called initially from client code versus the sql editor?

sql
DECLARE
  slash_position INT;
  value TEXT;
  entry_id UUID;
BEGIN
  -- Encontra a posição da última ocorrência do caractere '/'
  slash_position := strpos(reverse(new.short_url), '/');
  
  -- Extrai o valor após a última ocorrência do caractere '/'
  value := reverse(substring(reverse(new.short_url) from 1 for slash_position - 1));

  select id
  into entry_id
  from url_data
  WHERE slug = value;

  raise exception 'zzzz %', new;
  
  -- update public.report_data
  -- set url_id = 'eeff7d6b-6cd3-42ee-bab6-05b63262fb88'
  -- where id = new.id;

  -- raise exception 'zzzz %', entry_id;

  RETURN new;
END;

yes im loggin to check, but im gettin null on new

Do you have the trigger as row level versus statement level?

What do I need to do, sorry?

How did you create the trigger?

from function tab

let me create again, so

That is the function not the trigger

ok im creating my function again

My guess is your problem is in the trigger, that is a different screen

That is the trigger screen and statement at bottom is wrong.

i changed

Yes

now worked