Untitled

create function one() returns setof uuid as $$
	declare
		r record;
	begin
		for r in
		select * from "SysUserInRole" where "SysRoleId" = '2ba9285d-a0ad-4570-84ad-1621135353f4'
		loop 
			if not exists(select * from "SysUserInRole" where "SysUserId" = r."SysUserId" and "SysRoleId" = 'bbeecdf9-86df-4116-8771-533d147471da') then 
			return next "SysUserId" from "SysUserInRole" where "Id" = r."Id";
			end if;
		end loop;
	end;
$$ language PLPGSQL;

select one();
drop function one();