Re: Partial indexes

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