ACS3 Data Model

     1: function ad_group_member_admin_role_p
     2:   (v_user_id IN integer, v_group_id IN integer)
     3: return varchar
     4: IS
     5:   n_rows  integer;
     6: BEGIN
     7:   select count(*) into n_rows
     8:    from user_group_map
     9:    where user_id = v_user_id
    10:    and group_id = v_group_id
    11:    and lower(role) = 'administrator';
    12:   IF n_rows > 0 THEN
    13:     return 't';
    14:   ELSE
    15:     return 'f';
    16:   END IF;
    17: END;