Hello!
I apologize in advanced if this has been previously discussed;
A json(b)_agg() will produce the following result when no results are passed in:
"[null]"
per:
select jsonb_agg((select 1 where false));
I believe, generally speaking, '[]' would be the more appropriate output.
Would postgres welcome a patch to handle the empty case of json(b)_agg?
Thanks!
---
Jordan Deitch