Код: Выделить всё
CREATE OR REPLACE FUNCTION public.f_baseuser_ins (
iarh boolean,
iregdata date,
isfam varchar,
isimja varchar,
isotch varchar,
ibrig integer,
out out_baseuser_id bigint
)
RETURNS bigint AS
$body$
DECLARE
iuserfio VARCHAR(100);
BEGIN
IF iarh IS NULL THEN
iarh := FALSE;
END IF;
iuserfio := isfam || ' ' || isimja;
IF isotch <> '' THEN
iuserfio := iuserfio || ' ' || isotch;
END IF;
INSERT INTO baseuser
(
userfio,
arh,
regdata,
sfam,
simja,
sotch,
brig
)
VALUES
(iuserfio,
iarh,
iregdata,
isfam,
isimja,
isotch,
ibrig
)RETURNING baseuser_id INTO out_baseuser_id;
RETURN;
END;