ยฉ 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabaseโ€ข4y agoโ€ข
2 replies
Joakim

RPC to add to an array

Hi! I got an column in my store_table for likes.
It takes in UID. so a authenticated user can like a store in this case.
see image.

Now I need to create an RPC takes takes in two parameters. the UID, and store_id, the UID has type uid, and store_id is type int4

so append user_id to likes where store_id is equal to the store_id selected

It's my first time writing one and struggle to find exactly what I need.
So hoping for some help in writing it, thanks ๐Ÿ˜„
image.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

How to unpack an array of arrays with an RPC
SupabaseSSupabase / help-and-questions
4y ago
RPC custom function to add object to JSONB array?
SupabaseSSupabase / help-and-questions
4y ago
how can I pass an array of objects to an rpc call?
SupabaseSSupabase / help-and-questions
4y ago
SOLVED] How to cast an RPC with array? [FEATURE PROPOSAL]
SupabaseSSupabase / help-and-questions
4y ago