PostgreSQL array_agg order

by

Use an ORDER BY, like this example from the manual:

SELECT array_agg(a ORDER BY b DESC) FROM table;

More Related Contents:

  1. What is PostgreSQL equivalent to autoincrement?
  2. How do I specify a password to ‘psql’ non-interactively?
  3. INSERT with dynamic table name in trigger function
  4. psql: FATAL: Ident authentication failed for user “postgres”
  5. Use multiple conflict_target in ON CONFLICT clause
  6. PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
  7. What is the format for the PostgreSQL connection string / URL?
  8. Go and IN clause in Postgres
  9. Where does PostgreSQL store the database?
  10. Is there a way to disable function overloading in Postgres
  11. Grant all on a specific schema in the db to a group role in PostgreSQL
  12. Can I make a plpgsql function return an integer without using a variable?
  13. Migrate database from Postgres to MySQL [closed]
  14. How can I start PostgreSQL on Windows?
  15. PostgreSQL – max number of parameters in “IN” clause?
  16. SQLAlchemy, Psycopg2 and Postgresql COPY
  17. How to find out if an upsert was an update with PostgreSQL 9.5+ UPSERT?
  18. Why can I create a table with PRIMARY KEY on a nullable column?
  19. Oracle SQL Developer and PostgreSQL
  20. PostgreSQL array of elements that each are a foreign key
  21. How to reset sequence in postgres and fill id column with new data?
  22. Differentiate inserted and updated rows in UPSERT using system columns
  23. Custom ORDER BY Explanation
  24. Configure JPA to let PostgreSQL generate the primary key value
  25. ERROR: unterminated quoted string at or near
  26. How can I send some http request from postgresql function or trigger
  27. Hashing a String to a Numeric Value in PostgreSQL
  28. Spring Docker container cannot access Postgres Docker container
  29. Format specifier for integer variables in format() for EXECUTE?
  30. PostgreSQL composite primary key

Leave a Comment