Annotation: office.get_office_id_by_user_id

CREATE OR REPLACE FUNCTION office.get_office_id_by_user_id(user_id integer_strict)
RETURNS integer

Information: office.get_office_id_by_user_id

Schema office
Function Name get_office_id_by_user_id
Arguments user_id integer_strict
Owner postgres
Result Type integer
Description

Implementation: office.get_office_id_by_user_id

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