row level security stuck with recursive checking with SELECT

create or replace function is_participating(param_room_id uuid)
returns boolean as $$
  select exists
    (
      select 1
      from participations
      where room_id = param_room_id
        and user_id = auth.uid()
        and (role = 'admin' or role = 'user')
        and status = 'granted'
    );
$$ language sql;

create policy "Can view participations of rooms where they already participate." on participations for select using (is_participating(room_id));