Tom Lane wrote:
> elein <elein@varlena.com> 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