Re: [sqlalchemy] Creating a partial unique index on SQLite

2014-09-01 Thread Michael Bayer
On Sep 1, 2014, at 4:29 AM, Lele Gaifax wrote: > Hi all, > > I'd need to create a partial index on a SQLite database > (http://www.sqlite.org/partialindex.html), but it seems that there's no > equivalent of "postgresql_where" on the sqlite dialect. > > The need arises from wanting a unique con

[sqlalchemy] Creating a partial unique index on SQLite

2014-09-01 Thread Lele Gaifax
Hi all, I'd need to create a partial index on a SQLite database (http://www.sqlite.org/partialindex.html), but it seems that there's no equivalent of "postgresql_where" on the sqlite dialect. The need arises from wanting a unique constraint on a subset of the dataset. Other than properly impleme