Tom Lane wrote:
elein <elein@xxxxxxxxxxx> writes:I think I want to: create unique index pk on table tbl (keyp1, keyp2);
don't you want create unique inde pk on table tbl (keyp1, keyp2) where keyp3 is null here?
create unique index range on table tbl (keyp1, keyp2, keyp3) where keyp3 is not null;Are these indexes redundant given uniqueness requirement and the type of queries that will be run against the table?
greetings, Florian Pflug
