| 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 |
|---|
