Annotation: transactions.refresh_materialized_views

CREATE OR REPLACE FUNCTION transactions.refresh_materialized_views(_office_id integer)
RETURNS void

Information: transactions.refresh_materialized_views

Schema	transactions
Function Name	refresh_materialized_views
Arguments	_office_id integer
Owner	postgres
Result Type	void
Description

Implementation: transactions.refresh_materialized_views

CREATE OR REPLACE FUNCTION transactions.refresh_materialized_views(_office_id integer)
 RETURNS void
 LANGUAGE plpgsql
AS $function$
BEGIN
        REFRESH MATERIALIZED VIEW transactions.trial_balance_view;
        REFRESH MATERIALIZED VIEW transactions.verified_stock_transaction_view;
        REFRESH MATERIALIZED VIEW transactions.verified_transaction_mat_view;
        REFRESH MATERIALIZED VIEW transactions.verified_cash_transaction_mat_view;
END
$function$