Annotation: core.get_periods

CREATE OR REPLACE FUNCTION core.get_periods(_date_from date, _date_to date)
RETURNS core.period[]

Information: core.get_periods

Schema	core
Function Name	get_periods
Arguments	_date_from date, _date_to date
Owner	postgres
Result Type	core.period[]
Description

Implementation: core.get_periods

CREATE OR REPLACE FUNCTION core.get_periods(_date_from date, _date_to date)
 RETURNS core.period[]
 LANGUAGE plpgsql
AS $function$
BEGIN
    RETURN 
        array_agg
        (
            (
                core.get_frequency_setup_code_by_frequency_setup_id(frequency_setup_id),
                core.get_frequency_setup_start_date_frequency_setup_id(frequency_setup_id),
                core.get_frequency_setup_end_date_frequency_setup_id(frequency_setup_id)
            )::core.period
        )::core.period[]
    FROM core.frequency_setups
    WHERE value_date BETWEEN _date_from AND _date_to;
END
$function$