maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_coverage(integer, date)
Parameters
Name
Type
Mode
in_iddevice
integer
IN
in_day
date
IN
Definition
declare rec RECORD; begin FOR rec IN SELECT e.* FROM event e WHERE iddevice = in_iddevice and creationdate between in_day and (in_day + '1 day'::interval) order by creationdate LOOP RETURN next rec; END LOOP; end;