Using distinct in the json_agg works only with a jsonb object.

SimonGoring · SimonGoring · commit 4bd0ead262e6 · 2020-09-16T15:32:43.000-07:00
diff --git a/function/da/chronologybyid.sql b/function/da/chronologybyid.sql
@@ -27,7 +27,7 @@ AS $function$
         chr.ageboundolder AS AgeOlder,
         chr.chronologyid AS ChronologyID,
         chr.ageboundyounger AS AgeYounger,
-        json_agg(DISTINCT json_build_object('DatasetType', dst.datasettype,
+        json_agg(DISTINCT jsonb_build_object('DatasetType', dst.datasettype,
                                      'DatasetID', ds.datasetid)) AS datasets,
         chr.notes AS Notes,
         chr.dateprepared AS DatePrepared
