[sqlalchemy] Creating PostgreSQL Index with ASC/DESC and NULLS FIRST/LAST

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)

Re: [sqlalchemy] Creating PostgreSQL Index with ASC/DESC and NULLS FIRST/LAST

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 >

Re: [sqlalchemy] Creating PostgreSQL Index with ASC/DESC and NULLS FIRST/LAST

Thanks! On 11/23/2015 09:06 PM, Mike Bayer wrote: > > 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