# Feature python-sql agregate ArrayAgg

**URL:** https://discuss.tryton.org/t/feature-python-sql-agregate-arrayagg/5580
**Category:** Ideas
**Tags:** python-sql
**Created:** [October 4, 2022, 2:42pm UTC](https://discuss.tryton.org/t/feature-python-sql-agregate-arrayagg/5580 "2022-10-04T14:42:18Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![wgs](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/w/c0e974/32.png) [@wgs](https://discuss.tryton.org/u/wgs)
#### Post date: [October 4, 2022, 2:42pm UTC](https://discuss.tryton.org/t/feature-python-sql-agregate-arrayagg/5580/1 "2022-10-04T14:42:19Z")

</div>

**Proposal**

This allows to create a query of many records already grouped into a list which can be used immediately.

**Implementation:**

```auto
class ArrayAgg(Aggregate):
    __slots__ = ()
    _sql = 'ARRAY_AGG'

```

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [October 4, 2022, 4:12pm UTC](https://discuss.tryton.org/t/feature-python-sql-agregate-arrayagg/5580/2 "2022-10-04T16:12:55Z")

</div>

We do not include it because it is a specific function of PostgreSQL and not part of any SQL standard.