Routines

Routines

Name	Type	Language	Deterministic	Return Type	Security Restriction	Comments
update_recdatemodified()	FUNCTION	plpgsql	false	trigger	INVOKER
contacts_delete_fn()	FUNCTION	plpgsql	false	trigger	INVOKER
sites_update_bbox_fn()	FUNCTION	plpgsql	false	trigger	INVOKER
datasettypecontrib(startperiod integer DEFAULT 0, endperiod integer DEFAULT 1)	FUNCTION	sql	false	TABLE(datasettype character varying, counts bigint)	INVOKER
getalltables(_schema text)	FUNCTION	sql	false	TABLE(schema text, "table" text, "column" text, data_type text, "default" text)	INVOKER
rawbymonth(startperiod integer DEFAULT 0, endperiod integer DEFAULT 1)	FUNCTION	sql	false	TABLE(datasets bigint, sites bigint, publications bigint, authors bigint, countrygpid bigint, observations numeric)	INVOKER
stewardcontrib(startperiod integer DEFAULT 0, endperiod integer DEFAULT 1)	FUNCTION	sql	false	TABLE(databasename character varying, counts bigint)	INVOKER
update_recdatecreated()	FUNCTION	plpgsql	false	trigger	INVOKER
datasetcontribs(startperiod integer DEFAULT 0, endperiod integer DEFAULT 1)	FUNCTION	sql	false	TABLE(databasename character varying, counts bigint)	INVOKER
compute_cnratio()	FUNCTION	plpgsql	false	trigger	DEFINER
datasetsummary(startperiod integer DEFAULT 0, endperiod integer DEFAULT 1)	FUNCTION	sql	false	TABLE(databasename character varying, counts bigint)	INVOKER
datasetconstitdb(startperiod integer DEFAULT 0, endperiod integer DEFAULT 1)	FUNCTION	sql	false	TABLE(databasename character varying, counts bigint)	INVOKER