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