Re: it's a feature, but it feels like a bug

Hi,

I've bumped onto the following problem:
---------------------screenshot----------------------------
ztk=# create table test (a int, b int, c int, d bool, e int, primary key
(a,b,c,d));
CREATE TABLE
ztk=# create unique index leftone on test (a,b) where d is true;
 a unique index is there to indicate exactly one row as target
for the FK. This is what LEFTONE index does.