List:Internals« Previous MessageNext Message »
From:barries Date:November 21 2000 3:59pm
Subject:Re: Index with condition? [A distant idea]
View as plain text  
On Tue, Nov 21, 2000 at 08:47:00AM -0700, sasha@stripped wrote:
> >        UNIQUE ( person_id, ident_doc_type ) WHERE valid_to IS NULL
> 
> Monty - I think it is a good idea, and should not be too hard to do - you just
> check the expr before you update the key, and check it again before doing a key
> read - is there anything else involved, other than storing/retrieving the expr?

Is this the start of computed function indexes (I hope)?

- Barrie
Thread