On 11/23/2015 03:01 PM, Florian Rüchel wrote:
> Hey,
>
> I want to execute the following statement in the most SQLAlchemy way
> possible:
>
> CREATE INDEX ix_user_points ON "user" (points DESC NULLS LAST);
>
> So I want to add a "DESC NULLS LAST" or equivalent as per documentation
> (http://www.postgresql.org/docs/current/static/indexes-ordering.html)
this is supported directly
Index("ix_user_points", user.c.points.desc().nullslast())
>
> Can SQLAlchemy do this in any way and understand it? Alternatively:
> Where would be the correct spot to execute the explicit SQL? I was
> thinking about Schema Events here.
>
> Regards,
> Florian
>
> --
> 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 sqlalchemy+unsubscr...@googlegroups.com
> <mailto:sqlalchemy+unsubscr...@googlegroups.com>.
> To post to this group, send email to sqlalchemy@googlegroups.com
> <mailto:sqlalchemy@googlegroups.com>.
> Visit this group at http://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
--
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 sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
