valintarekisteri
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_viestit_history()
Parameters
Name
Type
Mode
IN
Definition
begin insert into viestit_history(hakemus_oid, hakukohde_oid, syy, lahetetty, lahettaminen_aloitettu, transaction_id, system_time) values (old.hakemus_oid, old.hakukohde_oid, old.syy, old.lahetetty, old.lahettaminen_aloitettu, old.transaction_id, tstzrange(lower(old.system_time), now(), '[)')); return null; end;