Re: Multiple Aggregations Order

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: João Haas <joao(dot)ca(dot)haas(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Multiple Aggregations Order
Date: 2020-01-14 20:43:51
Message-ID: CAKFQuwZKcDHtvppy5O34qbwxsPs28SRtY3fEvU5HAwR=T41p+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday, January 14, 2020, João Haas <joao(dot)ca(dot)haas(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tulqin Navruzov 2020-01-14 20:44:48 Fwd: Postgresql Data corruption
Previous Message Tom Lane 2020-01-14 20:22:00 Re: 12.1 not useable: clientlib fails after a dozen queries (GSSAPI ?)