Skip to content

Commit edf505f

Browse files
committed
Oops, this is the chonology by id function :)
1 parent 2d0f448 commit edf505f

File tree

1 file changed

+1
-1
lines changed

1 file changed

+1
-1
lines changed

function/da/chronologybyid.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -27,7 +27,7 @@ AS $function$
2727
chr.ageboundolder AS AgeOlder,
2828
chr.chronologyid AS ChronologyID,
2929
chr.ageboundyounger AS AgeYounger,
30-
json_agg(json_build_object('DatasetType', dst.datasettype,
30+
json_agg(DISTINCT json_build_object('DatasetType', dst.datasettype,
3131
'DatasetID', ds.datasetid)) AS datasets,
3232
chr.notes AS Notes,
3333
chr.dateprepared AS DatePrepared

0 commit comments

Comments
 (0)