-- -- 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;