-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathinsertisometadata.sql
More file actions
16 lines (16 loc) · 1.29 KB
/
insertisometadata.sql
File metadata and controls
16 lines (16 loc) · 1.29 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
CREATE OR REPLACE FUNCTION ts.insertisometadata(_dataid integer,
_isomatanaltypeid integer DEFAULT NULL::integer,
_isosubstratetypeid integer DEFAULT NULL::integer,
_analystid integer DEFAULT NULL::integer,
_lab character varying DEFAULT NULL::character varying,
_labnumber character varying DEFAULT NULL::character varying,
_massmg double precision DEFAULT NULL::double precision,
_weightpercent double precision DEFAULT NULL::double precision,
_atomicpercent double precision DEFAULT NULL::double precision,
_reps integer DEFAULT NULL::integer)
RETURNS void
LANGUAGE sql
AS $function$
INSERT INTO ndb.isometadata(dataid, isomatanaltypeid, isosubstratetypeid, analystid, lab, labnumber, mass_mg, weightpercent, atomicpercent, reps)
VALUES (_dataid, _isomatanaltypeid, _isosubstratetypeid, _analystid, _lab, _labnumber, _massmg, _weightpercent, _atomicpercent, _reps)
$function$