viestinta
.kirjeet
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
luosisallonosa(_sisalto_rakenne bigint, _sisalto bigint, _rooli character varying)
Parameters
Name
Type
Mode
_sisalto_rakenne
bigint
IN
_sisalto
bigint
IN
_rooli
character varying
IN
Definition
declare jarjestys int; begin jarjestys := (select max(csc.jarjestys) from kirjeet.sisalto_rakenne_sisalto csc where csc.sisalto_rakenne = _sisalto_rakenne)+1; insert into kirjeet.sisalto_rakenne_sisalto(sisalto_rakenne, sisalto, rooli, jarjestys) values (_sisalto_rakenne, _sisalto, _rooli, jarjestys); return jarjestys; end;