Annotation: office.get_role_code_by_user_name

CREATE OR REPLACE FUNCTION office.get_role_code_by_user_name(user_name text)
RETURNS text

Information: office.get_role_code_by_user_name

Schema	office
Function Name	get_role_code_by_user_name
Arguments	user_name text
Owner	postgres
Result Type	text
Description

Implementation: office.get_role_code_by_user_name

CREATE OR REPLACE FUNCTION office.get_role_code_by_user_name(user_name text)
 RETURNS text
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT office.roles.role_code FROM office.roles, office.users
        WHERE office.roles.role_id=office.users.role_id
        AND office.users.user_name=$1
    );
END
$function$