blob: 0015c2c48432f025279f1db5912398a7f6e8af84 (
plain)
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
|
CREATE OR REPLACE FUNCTION insert_test (
integer, -- personid
boolean, -- headtracking
boolean, -- stereo
boolean, -- shadow
integer -- boxsizeid
) RETURNS integer AS $$
DECLARE
par_personid ALIAS FOR $1;
par_headtracking ALIAS FOR $2;
par_stereo ALIAS FOR $3;
par_shadow ALIAS FOR $4;
par_boxsizeid ALIAS FOR $5;
var_testid integer;
BEGIN
INSERT INTO tbl_test (
personid,
headtracking,
stereo,
shadow,
boxsizeid
) VALUES (
par_personid,
par_headtracking,
par_stereo,
par_shadow,
par_boxsizeid
);
SELECT INTO var_testid seq_test.last_value;
RETURN var_testid;
END;
$$ LANGUAGE plpgsql;
|