Results 2 issues of Carlos Piña Martinez

How can I create a Postgres array ordered by some criteria? Sort like: ```sql SELECT ARRAY_AGG(date ORDER BY date DESC) "dates" FROM ... ``` I know `ARRAY_AGG` is not supported...