Winnipuhвыполняю так:
select GetRestrictedDescriptors(0,'1111');
пишет:
ERROR: function getrestricteddescriptors(integer, "unknown") does not exist
HINT: No function matches the given name and argument types. You may need to add explicit type casts.


???


Вот сама скомпилированная функция:

CREATE OR REPLACE FUNCTION "public"."GetRestrictedDescriptors" (bRestrictedGroups INTEGER, role_name VARCHAR) RETURNS SETOF "public"."uuid" AS
$body$
BEGIN
IF bRestrictedGroups = 0
THEN
begin
if role_name is null then
--insert into @out(descriptor_id)
select distinct descriptor_id from dbo.role_descr_restriction r
inner join dbo.user_roles u
on u.name=r.role_name;
else
-- --insert into @out(descriptor_id)
select distinct descriptor_id from dbo.role_descr_restriction
where role_name=@role_name;
end if;
end;
END IF;
END;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;
элементарно, ватсон
select "GetRestrictedDescriptors"(0,'1111');