valintapisteservice
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
update_valintapiste_history()
Parameters
Name
Type
Mode
IN
Definition
begin insert into valintapiste_history ( hakemus_oid, tunniste, arvo, osallistuminen, tallettaja, system_time, transaction_id ) values ( old.hakemus_oid, old.tunniste, old.arvo, old.osallistuminen, old.tallettaja, tstzrange(lower(old.system_time), now(), '[)'), old.transaction_id ); return null; end;