This ap function was returning the wrong type.

SimonGoring · SimonGoring · commit a728fa384cab · 2019-04-03T14:13:14.000-07:00
diff --git a/function/ap/gettaxaindatasets.sql b/function/ap/gettaxaindatasets.sql
@@ -1,12 +1,15 @@
 CREATE OR REPLACE FUNCTION ap.gettaxaindatasets()
- RETURNS TABLE(taxonid integer, taxonname character varying, taxagroupid character varying, datasettypeid integer)
+ RETURNS TABLE(taxonid integer,
+               taxonname character varying,
+               taxagroupid character varying,
+               datasettypeid integer)
  LANGUAGE sql
 AS $function$
 SELECT t.taxonid, t.taxonname, t.taxagroupid, dtgt.datasettypeid
 FROM ndb.taxa AS t LEFT JOIN
 ndb.datasettaxagrouptypes AS dtgt ON t.taxagroupid = dtgt.taxagroupid INNER JOIN
-ndb.variables AS v ON t.taxonid = v.taxonid 
-WHERE t.valid = 1
+ndb.variables AS v ON t.taxonid = v.taxonid
+WHERE t.valid = True
 GROUP BY t.taxonid, t.taxonname, dtgt.datasettypeid, t.taxagroupid
 ORDER BY t.taxonname, dtgt.datasettypeid
 $function$
