jkvint/h2database

Add support for the SQL standard array aggregate function: ARRAY_AGG()

GoogleCodeExporter opened this issue · 0 comments

The SQL standard specifies the array aggregate function as such:

<array aggregate function> ::=
    ARRAY_AGG
        <left paren> <value expression> [ ORDER BY <sort specification list> ] <right paren>

This function is available in PostgreSQL, for instance, and is extremely useful 
in RDBMS that support arrays - such as PostgreSQL, HSQLDB and H2

See also this discussion here:
https://groups.google.com/forum/#!topic/h2-database/q05LJcToXBA

Original issue reported on code.google.com by lukas.eder@gmail.com on 5 Jun 2014 at 5:08