Re: Why no "array_sort" function? - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: Why no "array_sort" function?
Date
Msg-id alpine.DEB.2.22.394.2005081039440.914063@pseudo
Whole thread Raw
In response to Re: Why no "array_sort" function?  (Sergei Kornilov <sk@zsrv.org>)
List 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.



pgsql-hackers by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: Why no "array_sort" function?
Next
From: Laurenz Albe
Date:
Subject: COPY, lock release and MVCC