egdb3_11_7
.actor
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
insert_usr_activity(usr integer, ewho text, ewhat text, ehow text)
Parameters
Name
Type
Mode
usr
integer
IN
ewho
text
IN
ewhat
text
IN
ehow
text
IN
Definition
DECLARE new_row actor.usr_activity%ROWTYPE; BEGIN SELECT id INTO new_row.etype FROM actor.usr_activity_get_type(ewho, ewhat, ehow); IF FOUND THEN new_row.usr := usr; INSERT INTO actor.usr_activity (usr, etype) VALUES (usr, new_row.etype) RETURNING * INTO new_row; RETURN NEXT new_row; END IF; END;