Postgres supports this using the postgres_where keyword argument sent to Index(). Otherwise use DDL().
http://www.sqlalchemy.org/docs/05/reference/dialects/postgres.html?highlight=postgres_where#indexes http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/schema.html?highlight=ddl#sqlalchemy.schema.DDL On Dec 6, 2008, at 1:15 PM, jose wrote: > > Hi all, > > I would like to create an index with a condition, like this: > > CREATE UNIQUE INDEX univocita_codice_aziendale > on azienda (lower(codice_aziendale), stato_record) > WHERE stato_record = 'A' > > Is there a way to do that, using the Index() command? > > j > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---