© 2026 Hedgehog Software, LLC

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

How to query arrays?

I am getting this error whilst trying to make a query for array values.
could not find array type for data type text[]
could not find array type for data type text[]


here is my query:

    const { data, error } = await supabase
      .from('recipes')
      .select('*')
      .in('tags', ['Snack']);
    const { data, error } = await supabase
      .from('recipes')
      .select('*')
      .in('tags', ['Snack']);

Also, I converted my column from JSONB to Text[], does that make any difference?
Screenshot_2022-11-16_at_17.19.16.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? query to spit out query needed to create table
SupabaseSSupabase / help-and-questions
4y ago
How to unpack an array of arrays with an RPC
SupabaseSSupabase / help-and-questions
4y ago
How to transform query into function.
SupabaseSSupabase / help-and-questions
3y ago
How to order a joined query?
SupabaseSSupabase / help-and-questions
3y ago