organisaatio
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
migrate_organisaatio_names(_to character varying, _from character varying, OUT _rows character varying)
Parameters
Name
Type
Mode
_to
character varying
IN
_from
character varying
IN
_rows
character varying
OUT
Definition
BEGIN WITH rows AS ( insert into monikielinenteksti_values (id, value, key, index) (select mv2.id, mv2.value, _to, 0 from organisaatio o join monikielinenteksti m on o.nimi_mkt = m.id left join monikielinenteksti_values mv1 on m.id = mv1.id and mv1.key = _to join monikielinenteksti_values mv2 on m.id = mv2.id and mv2.key = _from where mv1.id is null) RETURNING 1 ) SELECT CONCAT(count(*), ' names inserted ') INTO _rows FROM rows; END;