Обсуждение: Neither column can be NULL if the column is part of the combination of primary key columns?

Поиск
Список
Период
Сортировка

Neither column can be NULL if the column is part of the combination of primary key columns?

От
Emi Lu
Дата:
Greetings,

A question about "combination of several columns " as primary key .

A table test (
col1 timestamp not null default now(),
col2 timestamp,
primary key (col1, col2)
);

If I setup primary key as the *combination* of (col1, col2), the col2
will be setup as "NOT NULL" automatically right?
(Although, I did not specify not null constraint for col2)

To allow *col2* to be NULL and make record combination (col1, col2)
unique, I should setup
unique (col1, col2) ?

Thanks,
Emi





Re: Neither column can be NULL if the column is part of the combination of primary key columns?

От
Jaime Casanova
Дата:
>
> To allow *col2* to be NULL and make record combination (col1, col2)
> unique, I should setup
> unique (col1, col2) ?
>
> Thanks,
> Emi
>

no, you must create a partial unique index...

create unique index indice_col2 on table(col1, col2) where col2 is not null;

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)