From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Aleksander Alekseev <aleksander(at)timescale(dot)com> |
Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Proposal: array_unique_agg() function |
Date: | 2022-03-01 13:46:53 |
Message-ID: | CAFj8pRAyNnojDUR=jbED=DoXMMJkOwKPXZVmy_qMLejCSy8GWw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi
út 1. 3. 2022 v 14:39 odesílatel Aleksander Alekseev <
aleksander(at)timescale(dot)com> napsal:
> Hi hackers,
>
> I needed an aggregate function similar to array_agg() but which
> aggregates only unique values. As it turned out there is no convenient
> way of doing this. What I ended up doing instead was aggregating to
> JSONB keys and then converting a JSONB object to an array:
>
> SELECT array(select jsonb_object_keys(jsonb_object_agg(mycolumn, true)))
> FROM ...
>
> This works but doesn't seem to be the greatest user experience. I
> would like to submit a patch that adds array_unique_agg() function
> unless anyone has strong objections to this feature.
>
SELECT array_agg(DISTINCT ...) doesn't help?
Regards
Pavel
>
> --
> Best regards,
> Aleksander Alekseev
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Sergei Kornilov | 2022-03-01 13:48:48 | Re:Proposal: array_unique_agg() function |
Previous Message | Aleksander Alekseev | 2022-03-01 13:39:34 | Proposal: array_unique_agg() function |