Re: PRIMARY KEY on a *group* of columns imply that each column is NOT

Поиск
Список
Период
Сортировка
От Stephane Bortzmeyer
Тема Re: PRIMARY KEY on a *group* of columns imply that each column is NOT
Дата
Msg-id 20050427140632.GA29093@nic.fr
обсуждение исходный текст
Ответ на Re: PRIMARY KEY on a *group* of columns imply that each column is NOT  (ptjm@interlog.com (Patrick TJ McPhee))
Ответы Re: PRIMARY KEY on a *group* of columns imply that each  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: PRIMARY KEY on a *group* of columns imply that each  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
On Wed, Apr 27, 2005 at 05:19:32AM +0000,
 Patrick TJ McPhee <ptjm@interlog.com> wrote
 a message of 37 lines which said:

> but you should know that in SQL, unique constraints don't apply to
> rows containing null values

May be I should but I didn't.

> your table definition will be as you want it, but the constraint you
> want won't be there.

OK, I will try to write a custom trigger, then.



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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: PRIMARY KEY on a *group* of columns imply that each
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PRIMARY KEY on a *group* of columns imply that each column is NOT