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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
drop function resume.insert_education (
p_user_id int,
p_school character varying,
p_start_date character varying,
p_end_date character varying,
p_major character varying,
p_minor character varying,
p_degree character varying,
p_progress character varying
);
create or replace function resume.insert_education (
p_user_id int,
p_school character varying,
p_start_date character varying,
p_end_date character varying,
p_major character varying,
p_minor character varying,
p_degree character varying,
p_progress character varying
)
returns bigint
as $$
declare
l_id bigint;
begin
insert into resume.education (
user_id,
school,
start_date,
end_date,
major,
minor,
degree,
progress
) values (
p_user_id,
p_school,
p_start_date,
p_end_date,
p_major,
p_minor,
p_degree,
p_progress
) returning id into l_id;
return l_id;
end;
$$ language plpgsql;
|
