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
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
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