postgresql-for-doctrine icon indicating copy to clipboard operation
postgresql-for-doctrine copied to clipboard

Published 20 hours ago • verified publisher icon martin-georgiev

array_agg doesn't support ORDER BY

Open olek07 opened this issue 3 years ago • 1 comments

When I use the function like this array_agg(d.startDate ORDER BY d.startDate DESC), I get en error "[Syntax Error] line 0, col 64: Error: Expected Doctrine\ORM\Query\Lexer::T_CLOSE_PARENTHESIS, got 'ORDER'" Please fix it.

olek07 avatar Sep 19 '22 12:09 olek07

Hi @martin-georgiev,

Is this something that can be fixed?

ricardoee avatar Dec 16 '23 13:12 ricardoee