I have two separate supabase calls

const { data: mutualReviews, error: mutualError } = await supabase
        .from('reviews')
        .select('score, text, profiles!inner(*)')
        .eq('video_id', id)
        .neq('user_id', user.id)
        .in('profiles.twitter_handle', profile.twitter_follows)
        .contains('profiles.twitter_follows', [profile.twitter_handle])

      const { data: followsReviews, error: followsError } = await supabase
        .from('reviews')
        .select('score, text, profiles!inner(*)')
        .eq('video_id', id)
        .neq('user_id', user.id)
        .in('profiles.twitter_handle', profile.twitter_follows)
        .not('profiles.twitter_follows', 'contains', [profile.twitter_handle])

The only differentiating line is the final one, contains vs not. In this context not does not work at all. I think that maybe it only works for 'eq'?

well postgrest thinks it should: "To negate any operator, you can prefix it with not"... I've not tried on contains but it is supposed to work

I did try it just by itself

@User OK so looking at the supabase.js URL being generated for .not and what postgrest wants............. ta da! .not('tags','cs','{b,a}') works... LOL cs makes sense as that is what postgrest expects for contains... '{b,a}' works as a replacement for ['b','a'] used in the .contains. There maybe other ways to format that part. Key is the 'cs' instead of contains and then just getting an array with %7b and %7D to replace [] as brackets for the array in the URL which is what postgrest wants....

Wow thanks for the reply @User

The left part is the column name, the right part is a js array with your values... not a column... .contains['col',[a,b,c]) 'col' is a column in your table that is an array type.

Hm in this case the right part is just a single string

It is an array with one or more values to check if in the database col that is also an array

Oh okay

.in is totally different it compares a single value column to see if an array has that value in it.

I see

Good luck. Night.

Thank you!!