f_insert_date_series_of_bookingItems.sql

CREATE OR REPLACE FUNCTION f_insert_date_series_of_bookingItems(BIGINT, DATE, DATE, CHARACTER VARYING, DECIMAL)
  RETURNS INTEGER
LANGUAGE plpgsql
AS $_$DECLARE
  r RECORD;
  s NUMERIC;
BEGIN
  -- s = $2;
  FOR r IN SELECT generate_series($2 :: DATE, $3, $4::INTERVAL) :: DATE AS mdate
           OFFSET 1
  LOOP
    INSERT INTO booking_items (booking_id, date_of_dues, amount, created_at, updated_at)
    VALUES ($1, r.mdate, $5, now() :: TIMESTAMP WITHOUT TIME ZONE, now() :: TIMESTAMP WITHOUT TIME ZONE);
  END LOOP;
  RETURN 1;
END;$_$;