--
-- acs_rel_type__create_role/1
--
create or replace function acs_rel_type__create_role(
  character varying
) returns int4 as $$

declare
  create_role__role                   alias for $1;  
begin
    perform acs_rel_type__create_role(create_role__role, NULL, NULL);
    return 0; 
end;$$ language plpgsql;


--
-- acs_rel_type__create_role/3
--
create or replace function acs_rel_type__create_role(
  character varying,
  character varying,
  character varying
) returns int4 as $$

declare
  create_role__role                   alias for $1;  
  create_role__pretty_name            alias for $2;  -- default null  
  create_role__pretty_plural          alias for $3;  -- default null
begin
    insert into acs_rel_roles
     (role, pretty_name, pretty_plural)
    values
     (create_role__role, coalesce(create_role__pretty_name,create_role__role), coalesce(create_role__pretty_plural,create_role__role));

    return 0; 
end;$$ language plpgsql;