Re: min/max aggregation for jsonb

2023-04-10 Thread Daneel Yaitskov
', jsonb_build_object( 'a', cast(array_to_json(array_agg( DISTINCT _meta_a)) AS "jsonb"))) AS _meta_max_a FROM t On Fri, Mar 3, 2023 at 5:41 AM David Rowley wrote: > On Fri, 3 Mar 2023 at 23:17, Daneel Yaitskov wrote: > > I wanted to use min/max aggregation funct

min/max aggregation for jsonb

2023-03-03 Thread Daneel Yaitskov
Hi, I wanted to use min/max aggregation functions for jsonb type and noticed there is no functions for this type, meanwhile string/array types are supported. Is there a concern about implementing support for jsonb in min/max? jsonb is a byte array. json faces same limitations. -- Best