Annotation: office.get_office_code_by_id

CREATE OR REPLACE FUNCTION office.get_office_code_by_id(office_id integer_strict)
RETURNS text

Information: office.get_office_code_by_id

Schema office
Function Name get_office_code_by_id
Arguments office_id integer_strict
Owner postgres
Result Type text
Description

Implementation: office.get_office_code_by_id

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$