On Wed, Jan 20, 2016 at 4:28 AM, Konstantin Knizhnik <k.knizh...@postgrespro.ru> wrote: > Please notice that such alter table statement, changing condition for > partial index, is not supported now. > But I do not see any principle problems with supporting such construction. > We should just include in the index all records which match new condition > and do not match old condition: > > ts < '21/01/2016' and not (ts < '20/01/2016')
You'd also need to remove any rows from the index that match the old condition but not the new one. In your example, that's impossible, but in general, it's definitely possible. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers