RPC function doesn't work

BEGIN
  UPDATE public.kisis_cache
  SET cached=array_append(cached, id_to_cache) 
  WHERE user_id=cacher_id;
END

BEGIN
  UPDATE public.kisis_cache
  SET cached=array_append(cached, id_to_cache) 
  WHERE user_id=cacher_id;
END

BEGIN
  UPDATE public.kisis_cache
  SET cached=array_append(cached, id_to_cache) 
  WHERE user_id=cacher_id;
END

BEGIN
  UPDATE public.kisis_cache
  SET cached=array_append(cached, id_to_cache) 
  WHERE user_id=cacher_id;
END

I want my function to append a new value to existing array stored in cached column (type: textarray). So I wanted to append it based on user_id. Tried to check logs but didn't find any errors. Guys, could you help me please?

RPC function doesn't work

Similar Threads

Similar Threads

Similar Threads