Home > mailing lists

Re: Multiple Aggregations Order - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Multiple Aggregations Order
Date	January 14, 2020 23:43:51
Msg-id	CAKFQuwZKcDHtvppy5O34qbwxsPs28SRtY3fEvU5HAwR=T41p+g@mail.gmail.com Whole thread Raw
In response to	Multiple Aggregations Order (João Haas <joao.ca.haas@gmail.com>)
Responses	Re: Multiple Aggregations Order
List	pgsql-general

On Tuesday, January 14, 2020, João Haas <joao.ca.haas@gmail.com> wrote:

SELECT tb.*, array_agg(conn.child_id), array_agg(conn.kind)

Create a custom type (using row(...) might work...?) with the relevant fields and “...array_agg((child_id, kind)::custom_type order by ...”?

David J.

From: Michael Lewis
Date: 14 January 2020, 22:48:55
Subject: Re: Multiple Aggregations Order

From: Tulqin Navruzov
Date: 14 January 2020, 23:44:48
Subject: Fwd: Postgresql Data corruption