© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
4 replies
floyare

Insert or delete only one value from json array in table.

So I have my table with json column with example values like this:
[1,2,9]
[1,2,9]
. Now I want to insert values into this array without downloading current array's state.

Now I'm doing it by selecting current array's state and updating it with inserted or deleted number but I want to do it with one request. I looked up in docs for
upsert()
upsert()
method but I don't think so it'll work that way. Any ideas?
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

realtime only emitting DELETE events no INSERT or UPDATE events
SupabaseSSupabase / help-and-questions
4y ago
How to insert to multiple tables in one request?
SupabaseSSupabase / help-and-questions
4y ago
Storage only or storage + table?
SupabaseSSupabase / help-and-questions
2y ago
Update json file from define as array?
SupabaseSSupabase / help-and-questions
4y ago