RLS Policy with array

Hey all,
I have an RLS policy that I am trying to update from a string to an array. Currently it takes one string, but I want it to take a list of strings that map to a column.

I have setup using the community custom claims library and my original rls function was setup as

(get_my_agency() = agency)


but what I want is something like this

(agency contains(get_my_agencies())


is this possible or performnat?


https://github.com/supabase-community/supabase-custom-claims
GitHub
How to implement custom claims with Supabase. Contribute to supabase-community/supabase-custom-claims development by creating an account on GitHub.
Was this page helpful?