Skip to content

Add support for multiple expressions in order by clause for aggregate functions #875

Closed
@mustafasrepo

Description

@mustafasrepo

sqlparser can parse query below successfully,

SELECT ARRAY_AGG(x ORDER BY x) AS a FROM T

However, it cannot parse query below

SELECT ARRAY_AGG(x ORDER BY x, y) AS a FROM T

It assumes that order by will contain single entry. However, second form is valid also. Postgres can run queries in the second form.
Add support for multiple expression in the order by clause for aggregate functions.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions