GitLab

Created by: alesso-x

Migration

ALTER TABLE public.disaggregated_bill
  ADD COLUMN unit_price FLOAT NOT NULL DEFAULT 0;

DROP FUNCTION IF EXISTS public.delete_disaggregated_bill(integer);

CREATE OR REPLACE FUNCTION public.delete_disaggregated_bill(IN in_account_id INTEGER)
  RETURNS TABLE(
    id             INTEGER,
    account_id     INTEGER,
    bill_from_date DATE,
    bill_to_date   DATE,
    heating_usage  FLOAT,
    cooling_usage  FLOAT,
    other_usage    FLOAT,
    dhw            FLOAT,
    lighting       FLOAT,
    cooking        FLOAT,
    plug_load      FLOAT,
    miscellaneous  FLOAT,
    unit_price     FLOAT
  ) AS $BODY$
BEGIN
  RETURN QUERY
  DELETE FROM disaggregated_bill
  WHERE public.disaggregated_bill.account_id = in_account_id
  RETURNING *;
END;
$BODY$
LANGUAGE plpgsql
VOLATILE
COST 100
ROWS 1000;