maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_event_part_by_iddevice()
Parameters
Name
Type
Mode
Definition
DECLARE BEGIN EXECUTE format('INSERT INTO %s_%s_%s SELECT $1.*',TG_TABLE_NAME,lpad(((NEW.iddevice / 500) * 500)::varchar,6,'0'),lpad((((NEW.iddevice / 500) * 500) + 500 - 1)::varchar,6,'0')) USING NEW; RETURN NULL; EXCEPTION WHEN OTHERS THEN RAISE NOTICE '%,%', SQLSTATE, SQLERRM; RETURN NEW; END;