1 CREATE SCHEMA timewarp;
3 CREATE OR REPLACE FUNCTION timewarp.period_fill_all()
10 PERFORM timewarp.period_fill(period_id) FROM (
20 LANGUAGE plpgsql VOLATILE
23 ALTER FUNCTION timewarp.period_fill_all()
28 CREATE OR REPLACE FUNCTION timewarp.period_fill(integer)
33 i_period_id ALIAS FOR $1;
49 period_id = i_period_id;
64 period_id = i_period_id;
71 period_start = r_periodview.period_start,
72 period_end = r_periodview.period_end,
73 period_closed = r_periodview.period_closed,
74 period_freeze = r_periodview.period_freeze,
75 period_initial = r_periodview.period_initial,
76 period_name = r_periodview.period_name,
77 period_yearperiod_id = r_periodview.period_yearperiod_id,
78 period_quarter = r_periodview.period_quarter,
79 period_number = r_periodview.period_number
82 period_id = i_period_id;
86 INSERT INTO timewarp.period (
87 period_id, period_start,
88 period_end, period_closed,
89 period_freeze, period_initial,
90 period_name, period_yearperiod_id,
91 period_quarter, period_number
93 r_periodview.period_id, r_periodview.period_start,
94 r_periodview.period_end, r_periodview.period_closed,
95 r_periodview.period_freeze, r_periodview.period_initial,
96 r_periodview.period_name, r_periodview.period_yearperiod_id,
97 r_periodview.period_quarter, r_periodview.period_number
105 LANGUAGE plpgsql VOLATILE
108 ALTER FUNCTION timewarp.period_fill(integer)
114 SELECT timewarp.period_fill_all();