-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinsertradiocarbon.sql
More file actions
18 lines (18 loc) · 1.35 KB
/
insertradiocarbon.sql
File metadata and controls
18 lines (18 loc) · 1.35 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
CREATE OR REPLACE FUNCTION ts.insertradiocarbon(_geochronid integer,
_radiocarbonmethodid integer DEFAULT NULL::integer,
_percentc double precision DEFAULT NULL::double precision,
_percentn double precision DEFAULT NULL::double precision,
_delta13c double precision DEFAULT NULL::double precision,
_delta15n double precision DEFAULT NULL::double precision,
_cnratio double precision DEFAULT NULL::double precision,
_masscmg double precision DEFAULT NULL::double precision,
_percentcollagen double precision DEFAULT NULL::double precision,
_reservoir double precision DEFAULT NULL::double precision)
RETURNS void
LANGUAGE sql
AS $function$
INSERT INTO ndb.radiocarbon(geochronid, radiocarbonmethodid, percentc,
percentn, delta13c, delta15n, percentcollagen, reservoir, masscmg, cnratio)
VALUES (_geochronid, _radiocarbonmethodid, _percentc, _percentn, _delta13c,
_delta15n, _percentcollagen, _reservoir, _masscmg, _cnratio)
$function$