Cleaning up some of the bigger API functions.

SimonGoring · SimonGoring · commit 53ad461de18d · 2023-04-13T14:54:34.000-07:00
Minor changes, that allow me to make sure things are named properly and can be executed from the sql files.
diff --git a/function/doi/01_datasetinfo.sql b/function/doi/01_datasetinfo.sql
@@ -37,7 +37,7 @@ SELECT DISTINCT dts.datasetid,
 							                            'database', cstdb.databasename,
 							                                 'doi', doi.dois,
 													   'datasetpi', dsau.authors,
-														'agerange', agerange.ages))
+														'agerange', agerange.ages)) AS site
 FROM
          ndb.datasets AS dts
   LEFT OUTER JOIN                      ndb.collectionunits AS clu      ON clu.collectionunitid = dts.collectionunitid
@@ -96,7 +96,7 @@ SELECT DISTINCT dts.datasetid,
 							                                       'database', cstdb.databasename,
 							                                            'doi', doi.dois,
 																                    'datasetpi', dsau.authors,
-																                     'agerange', agerange.ages))
+																                     'agerange', agerange.ages)) AS site
 FROM
 ndb.datasets AS dts LEFT OUTER JOIN
 ndb.collectionunits AS clu ON clu.collectionunitid = dts.collectionunitid LEFT OUTER JOIN
diff --git a/function/doi/ndbdata.sql b/function/doi/ndbdata.sql
@@ -68,7 +68,7 @@ WITH dssamples AS (
 	WHERE ds.datasetid = dsid
 	GROUP BY ds.datasetid, dsinfo.dataset
 
-$function$
+$function$;
 
 CREATE OR REPLACE FUNCTION doi.ndbdata(dsid integer[])
  RETURNS TABLE(datasetid integer, data jsonb)
