eperusteetylops
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fix_pohja(ops_id bigint)
Parameters
Name
Type
Mode
ops_id
bigint
IN
Definition
UPDATE opetussuunnitelma SET pohja_id = oikea_pohja.pohja_id FROM (SELECT pohja_id FROM opetussuunnitelma_aud WHERE pohja_id IS NOT NULL AND id = ops_id ORDER BY rev DESC LIMIT 1) AS oikea_pohja WHERE id = ops_id; UPDATE opetussuunnitelma_aud SET pohja_id = oikea_pohja.pohja_id FROM (SELECT pohja_id FROM opetussuunnitelma_aud WHERE pohja_id IS NOT NULL AND id = ops_id ORDER BY rev DESC LIMIT 1) AS oikea_pohja WHERE id = ops_id;