UNIQUE KEY with null value...
| От | Diego |
|---|---|
| Тема | UNIQUE KEY with null value... |
| Дата | |
| Msg-id | 4367AF54.6010909@unimedijui.com.br обсуждение исходный текст |
| Ответы |
Re: UNIQUE KEY with null value...
Re: UNIQUE KEY with null value... Re: UNIQUE KEY with null value... Re: UNIQUE KEY with null value... |
| Список | pgsql-admin |
Hi, I´m a brazilian programmer! I have a question about Postgres UNIQUE KEY. Look: (Step 1) CREATE TABLE test ( id integer not null primary key, id_uni integer not null, cod integer, name varchar(40), constraint test_uk unique(id_uni, cod) ) (Step 2) insert into test (id, id_uni, cod, name) values (1, 1, null, 'A') (Step 3) insert into test (id, id_uni, cod, name) values (2, 1, null, 'B') =========> [Have the same UNIQUE KEY] Why postgresql don´t break insertion in this case???? Thanks Diego Ziquinatti Brazil
В списке pgsql-admin по дате отправления: