© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
2 replies
Абрамян_Игорь_1607835551

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


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?
unknown.png
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

UpdateUser doesn't work.
SupabaseSSupabase / help-and-questions
13mo ago
Rpc function invalid data
SupabaseSSupabase / help-and-questions
4y ago
Supabase start doesn't work
SupabaseSSupabase / help-and-questions
8mo ago
Realtime doesn't work locally.
SupabaseSSupabase / help-and-questions
4y ago