On Wed, Sep 19, 2018 at 5:56 AM pierre collet <[email protected]> wrote:
>
> 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).
>
> 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?
order_by can be turned into a "*order_by" if you can help by adding a
bug report , for now you can send in a ClauseList:
>>> from sqlalchemy.dialects.postgresql import aggregate_order_by
>>> from sqlalchemy import column
>>> from sqlalchemy.dialects import postgresql
>>> from sqlalchemy.sql.expression import ClauseList
>>> elem = aggregate_order_by(column('a'), ClauseList(column('b').asc(),
>>> column('c').desc()))
>>> print(elem.compile(dialect=postgresql.dialect()))
a ORDER BY b ASC, c DESC
>
> 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.
--
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.
