Re: min/max aggregation for jsonb

2023-05-02 Thread Peter Eisentraut
On 03.03.23 11:41, David Rowley wrote: On Fri, 3 Mar 2023 at 23:17, Daneel Yaitskov wrote: 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. It's not really clear to me how you'd want these

Re: min/max aggregation for jsonb

2023-04-10 Thread Daneel Yaitskov
Nonetheless PostgreSQL min/max functions don't work with JSON - array_agg distinct does! I was working on an experimental napkin audit feature. It rewrites a chain of SQL queries to thread through meta data about all computations contributed to every column. Every data column gets a meta column wi

Re: min/max aggregation for jsonb

2023-03-03 Thread David Rowley
On Fri, 3 Mar 2023 at 23:17, Daneel Yaitskov wrote: > 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. It's not really clear to me how you'd want these to sort. If you just want to sort b