How does PostgreSQL treat null values in unique composite constraints???

Поиск
Список
Период
Сортировка
От P G
Тема How does PostgreSQL treat null values in unique composite constraints???
Дата
Msg-id 20030408181235.61841.qmail@web13309.mail.yahoo.com
обсуждение исходный текст
Ответы Re: How does PostgreSQL treat null values in unique composite  (Dennis Gearon <gearond@cvc.net>)
Список pgsql-general
I have the following table with a unique constraint.

create table testt (
id int,
aa int,
bb int,
constraint pk_testt primary key (id),
constraint cons_testt unique (aa,bb));

Let's say I insert the following:

insert into testt values (1,2,null);
insert into testt values (2,2,null);

I thought this should fail because of the unique
constraint, but it doesn't.  How does PostgreSQL view
the null values in this constraint?  Will someone
explain why I am allowed to make this insertion?

TIA.

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: transfer data
Следующее
От: Medi Montaseri
Дата:
Сообщение: Re: Arrays ... need clarification....