Annotation: office.get_user_id_by_user_name

Information: office.get_user_id_by_user_name

Implementation: office.get_user_id_by_user_name

CREATE OR REPLACE FUNCTION office.get_user_id_by_user_name(user_name text)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT office.users.user_id FROM office.users
        WHERE office.users.user_name=$1
    );
END
$function$