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
|
drop function general.insert_gallery (
p_description text,
p_filename character varying,
p_mime_type character varying,
p_video_embed_url character varying,
p_hex text
);
create or replace function general.insert_gallery (
p_description text,
p_filename character varying,
p_mime_type character varying,
p_video_embed_url character varying,
p_hex text
)
returns bigint
as $$
declare
l_id bigint;
begin
insert into general.gallery (
description,
filename,
mime_type,
video_embed_url,
content
) values (
p_description,
p_filename,
p_mime_type,
p_video_embed_url,
decode(p_hex, 'hex')
) returning id into l_id;
return l_id;
end;
$$ language plpgsql;
|
