Re: Why no "array_sort" function?

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Sergei Kornilov <sk(at)zsrv(dot)org>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Why no "array_sort" function?
Date: 2020-05-08 08:46:35
Message-ID: alpine.DEB.2.22.394.2005081039440.914063@pseudo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hello Sergei,

> 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

Great, that's indeed enough for my usage, thanks for the tip!

The questions remains, why not provide an "array_sort", which could be
useful in other contexts?

--
Fabien.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Laurenz Albe 2020-05-08 08:58:24 COPY, lock release and MVCC
Previous Message Sergei Kornilov 2020-05-08 08:26:31 Re: Why no "array_sort" function?