Re: Why no "array_sort" function?

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>, PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Why no "array_sort" function?
Date: 2020-05-08 08:26:31
Message-ID: 652461588926062@mail.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

> mostly in an aggregation to show
> in a compact way what items were grouped together.

Aggregate functions have syntax for ordering: just "select array_agg(i order by i) from ...."
Described here: https://www.postgresql.org/docs/current/sql-expressions.html#SYNTAX-AGGREGATES

regards, Sergei

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2020-05-08 08:46:35 Re: Why no "array_sort" function?
Previous Message Virender Singla 2020-05-08 08:20:30 Postgres default FILLFACTOR value