sql/functions/resume.insert_resume.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

drop function resume.insert_resume (
    p_user_id int,
    p_name character varying
);

create or replace function resume.insert_resume (
    p_user_id int,
    p_name character varying
)
returns bigint
as $$
declare
  l_id bigint;
begin
    insert into resume.resume (
        user_id,
        name
    ) values (
        p_user_id,
        p_name
    ) returning id into l_id;

    return l_id;
end;
$$ language plpgsql;