Postgres Pro
Downloads
Home   >   mailing lists

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

From Sergei Kornilov
Subject Re: Why no "array_sort" function?
Date
Msg-id 652461588926062@mail.yandex.ru
Whole thread Raw
In response to Why no "array_sort" function?  (Fabien COELHO <coelho@cri.ensmp.fr>)
Responses Re: Why no "array_sort" function?
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Virender Singla
Date:
Subject: Postgres default FILLFACTOR value
Next
From: Fabien COELHO
Date:
Subject: Re: Why no "array_sort" function?