eperusteet
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
newosa(_id bigint, _tunniste text, _nimi bigint, _tila text, viiteid bigint, _rev integer)
Parameters
Name
Type
Mode
_id
bigint
IN
_tunniste
text
IN
_nimi
bigint
IN
_tila
text
IN
viiteid
bigint
IN
_rev
integer
IN
Definition
BEGIN PERFORM newOsa(_id, _tunniste, _nimi, _tila, _rev); UPDATE perusteenosaviite SET perusteenosa_id = _id WHERE id = viiteId; RETURN _id; END