RLS policy 'in' not working

Hi,

I'm trying to add an RLS policy to allow SELECT operation on a table.
My table looks something like this

room_table:
id (Primary Key) | room_members(array of uid) | room_owner_uid (uid)

where:
  • room_members is an array of the uid of authenticated users
  • room_owner_id is the uid of the owner.
In the
USING
expression, I tried to do:
uid() IN room_members
but it doesn't work.

A lot of example provided does not include this type of
USING
expression, so I have not had any luck getting the right way to do this.

Anyone knows how to do this? Thanks!
Was this page helpful?