-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinsertevent.sql
More file actions
8 lines (8 loc) · 845 Bytes
/
insertevent.sql
File metadata and controls
8 lines (8 loc) · 845 Bytes
1
2
3
4
5
6
7
8
CREATE OR REPLACE FUNCTION ts.insertevent(_eventtypeid integer, _eventname character varying, _c14age double precision DEFAULT NULL::double precision, _c14ageyounger double precision DEFAULT NULL::double precision, _c14ageolder double precision DEFAULT NULL::double precision, _calage double precision DEFAULT NULL::double precision, _calageyounger double precision DEFAULT NULL::double precision, _calageolder double precision DEFAULT NULL::double precision, _notes character varying DEFAULT NULL::character varying)
RETURNS integer
LANGUAGE sql
AS $function$
INSERT INTO ndb.events (eventtypeid, eventname, c14age, c14ageyounger, c14ageolder, calage, calageyounger, calageolder, notes)
VALUES (_eventtypeid, _eventname, _c14age, _c14ageyounger, _c14ageolder, _calage, _calageyounger, _calageolder, _notes)
RETURNING eventid
$function$