Обсуждение: Unique constraint and index-combination feature in 8.1
Hi, Is it somehow possible to create a UNIQUE constraint that relies on non-unique ONE-column indexes and uses index-combination feature in 8.1 ? The alternative, which we use now, is to create a unique MULTI-column index on the respective coulumns. Thanks __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
On Tue, Jun 20, 2006 at 03:40:37 -0700, ow <oneway_111@yahoo.com> wrote: > > Hi, > > Is it somehow possible to create a UNIQUE constraint that relies on non-unique > ONE-column indexes and uses index-combination feature in 8.1 ? > > The alternative, which we use now, is to create a unique MULTI-column index on > the respective coulumns. I am not completely sure what you are asking. But if you want a unique constraint over multiple columns you can specify a unique table constraint using multiple columns when you create a table. If you are looking for something else, it might help to give a bit more description about what you are looking for.
Are you saying you want to create a unique constraint across the indexes of 2 or more columns rather than across the columns themselves?
-Aaron
-Aaron
On 6/20/06, ow <oneway_111@yahoo.com> wrote:
Hi,
Is it somehow possible to create a UNIQUE constraint that relies on non-unique
ONE-column indexes and uses index-combination feature in 8.1 ?
The alternative, which we use now, is to create a unique MULTI-column index on
the respective coulumns.
Thanks