valintalaskenta
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_muokattu_jonosija_history()
Parameters
Name
Type
Mode
IN
Definition
begin insert into muokattu_jonosija_history ( id, created_at, hakukohde_oid, haku_oid, valintatapajono_oid, hakemus_oid, harkinnanvarainen, prioriteetti, selite, muutos, transaction_id, system_time ) values ( old.id, old.created_at, old.hakukohde_oid, old.haku_oid, old.valintatapajono_oid, old.hakemus_oid, old.harkinnanvarainen, old.prioriteetti, old.selite, old.muutos, old.transaction_id, tstzrange(old.created_at, now(), '[)') ); return null; end;