1 files changed, 35 insertions, 0 deletions
diff --git a/db_demo/sql/funcs/cr_func_insert_test.sql b/db_demo/sql/funcs/cr_func_insert_test.sql
new file mode 100644
index 0000000..0015c2c
--- /dev/null
+++ b/db_demo/sql/funcs/cr_func_insert_test.sql
@@ -0,0 +1,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;
+\ No newline at end of file