Annotation: office.get_user_name_by_user_id

CREATE OR REPLACE FUNCTION office.get_user_name_by_user_id(user_id integer)
RETURNS text

Information: office.get_user_name_by_user_id

Schema	office
Function Name	get_user_name_by_user_id
Arguments	user_id integer
Owner	postgres
Result Type	text
Description

Implementation: office.get_user_name_by_user_id

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