Deleted Flag/Unique Constraint

Поиск
Список
Период
Сортировка
От Bryan Murphy
Тема Deleted Flag/Unique Constraint
Дата
Msg-id bd8531800703291439i59b1ad15v1c89beba71545a4c@mail.gmail.com
обсуждение исходный текст
Ответы Re: Deleted Flag/Unique Constraint
Re: Deleted Flag/Unique Constraint
Список pgsql-general
Is it possible to declare a unique constraint in combination with a deleted flag?

For example, if I have a table like this:

CREATE TABLE
(
  ID NOT NULL PRIMARY KEY,
  Key VARCHAR(32) NOT NULL,
  Value VARCHAR(32) NOT NULL,
  Deleted INT NOT NULL DEFAULT 0
);

can I declare a unique constraint that only checks Key and Value when Deleted = 0?

Thanks,
Bryan

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