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?
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.