Skip to content

Cannot use DISTINCT with ARRAY_AGG #298

@jackbentley

Description

@jackbentley

The array_agg function does allow the use of DISTINCT but this throws a parse error:

ARRAY_AGG(DISTINCT m.name ORDER BY m.name ASC)
[Syntax Error] line 0, col 198: Error: Expected StateFieldPathExpression | string | InputParameter | FunctionsReturningStrings | AggregateExpression, got 'DISTINCT'

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions