Annotation: office.get_office_name_by_id

Information: office.get_office_name_by_id

Implementation: office.get_office_name_by_id

CREATE OR REPLACE FUNCTION office.get_office_name_by_id(office_id integer_strict)
 RETURNS text
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT office.offices.office_name FROM office.offices
        WHERE office.offices.office_id=$1
    );
END
$function$