Yes, I hadn't thought of that. Still if you wanted the index to be optimizable it might be better then not being able to delete it at all.

>In this case No, because you can't delete de same key twice or more.
>
>>
>>Hey that's a cool trick that I hadn't thought of before. But wouldn't it be better (for rushmore optimization) to add the deleted function in the index expression instead of using a filter.
>>
>>Maybe it doesn't make any difference... Just a thought I had.