search

ilovejs / h2database

Automatically exported from code.google.com/p/h2database
0 stars 1 forks source link

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

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
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