Commitbda1d14

committed

Return NULL from json_object_agg if it gets no rows.

This makes it consistent with the docs and with all other builtinaggregates apart from count().

1 parent54b8ed6 commitbda1d14Copy full SHA for bda1d14

File tree

-1

lines changed

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1973,7 +1973,7 @@ json_object_agg_finalfn(PG_FUNCTION_ARGS)`
`1973`	`1973`	`state=PG_ARGISNULL(0) ?NULL : (StringInfo)PG_GETARG_POINTER(0);`
`1974`	`1974`
`1975`	`1975`	`if (state==NULL)`
`1976`		`-PG_RETURN_TEXT_P(cstring_to_text("{}"));`
	`1976`	`+PG_RETURN_NULL();`
`1977`	`1977`
`1978`	`1978`	`appendStringInfoString(state," }");`
`1979`	`1979`

Comments

(0)