Hello, I am using SQLAlchemy on a PostgreSQL database and I was very pleased to find the aggregate_order_by function (http://docs.sqlalchemy.org/ccept ten/latest/dialects/postgresql.html#sqlalchemy.dialects.postgresql.aggregate_order_by <http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#sqlalchemy.dialects.postgresql.aggregate_order_by> ).
Though, I am wondering why the "order_by" argument of the function takes only one column while Postgresql definitely accepts to order by a set of columns: For instance: SELECT array_agg(status ORDER BY pk_col1, pk_col2) FROM table_with_pk_on_two_columns GROUP BY col_x; works fine on my PostgreSQL 9.6 database. Am I missing something or is this simply not yet implemented? Thank you. Pierre. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
