maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_ro_fast_event_tmp(integer, timestamp with time zone, timestamp with time zone)
Parameters
Name
Type
Mode
_iddevice
integer
IN
_startdate
timestamp with time zone
IN
_enddate
timestamp with time zone
IN
Definition
DECLARE _clock_timestamp timestamptz := clock_timestamp() + '5 minutes'::interval; BEGIN RETURN QUERY (SELECT * FROM public.event WHERE iddevice = _iddevice AND senddate BETWEEN _startdate AND _clock_timestamp AND (eventcat = 2 or eventcat is null)); END;