maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_partmigratedata(timestamp with time zone, timestamp with time zone)
Parameters
Name
Type
Mode
startdate
timestamp with time zone
IN
enddate
timestamp with time zone
IN
Definition
DECLARE dest_tablename varchar; t timestamptz; BEGIN t := startdate; WHILE t < enddate LOOP dest_tablename := 'fls_reading_part_p2015w'||to_char(t,'IW'); RAISE NOTICE '% ','INSERT INTO omnitracs.'||dest_tablename||' SELECT * FROM omnitracs.fls_reading WHERE senddate >= '||quote_literal(t)||' AND senddate <'||quote_literal(t + '1 week'::interval)||';'; --RAISE NOTICE '% %',dest_tablename,t; t := t + '1 week'::interval; END LOOP; RETURN TRUE; END;