Annotation: office.get_cash_repository_id_by_cash_repository_name

CREATE OR REPLACE FUNCTION office.get_cash_repository_id_by_cash_repository_name(text)
RETURNS integer

Information: office.get_cash_repository_id_by_cash_repository_name

Schema office
Function Name get_cash_repository_id_by_cash_repository_name
Arguments text
Owner postgres
Result Type integer
Description

Implementation: office.get_cash_repository_id_by_cash_repository_name

CREATE OR REPLACE FUNCTION office.get_cash_repository_id_by_cash_repository_name(text)
 RETURNS integer
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN
    (
        SELECT cash_repository_id
        FROM office.cash_repositories
        WHERE cash_repository_name=$1
    );
END
$function$