tarjontapulssi
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_toteutus_amounts_history()
Parameters
Name
Type
Mode
IN
Definition
begin insert into toteutus_amounts_history ( tyyppi_path, jotpa_amount, taydennyskoulutus_amount, tyovoimakoulutus_amount, pieni_osaamiskokonaisuus_amount, tila, amount, transaction_id, system_time ) values ( old.tyyppi_path, old.jotpa_amount, old.taydennyskoulutus_amount, old.tyovoimakoulutus_amount, old.pieni_osaamiskokonaisuus_amount, old.tila, old.amount, old.transaction_id, tstzrange(lower(old.system_time), now(), '[)') ); return null; end;