Annotation: office.is_valid_office_id

CREATE OR REPLACE FUNCTION office.is_valid_office_id(integer)
RETURNS boolean

Information: office.is_valid_office_id

Schema office
Function Name is_valid_office_id
Arguments integer
Owner postgres
Result Type boolean
Description

Implementation: office.is_valid_office_id

CREATE OR REPLACE FUNCTION office.is_valid_office_id(integer)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
        IF EXISTS(SELECT 1 FROM office.offices WHERE office_id=$1) THEN
                RETURN true;
        END IF;

        RETURN false;
END
$function$