Annotation: office.create_user

CREATE OR REPLACE FUNCTION office.create_user(role_id integer_strict, office_id integer_strict, user_name text, password text, full_name text, elevated boolean DEFAULT false)
RETURNS void

Information: office.create_user

Schema office
Function Name create_user
Arguments role_id integer_strict, office_id integer_strict, user_name text, password text, full_name text, elevated boolean DEFAULT false
Owner postgres
Result Type void
Description

Implementation: office.create_user

CREATE OR REPLACE FUNCTION office.create_user(role_id integer_strict, office_id integer_strict, user_name text, password text, full_name text, elevated boolean DEFAULT false)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
    INSERT INTO office.users(role_id,office_id,user_name,password, full_name, elevated)
    SELECT $1, $2, $3, $4,$5, $6;
    RETURN;
END
$function$