Re: Unique index VS unique constraint

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Unique index VS unique constraint
Дата
Msg-id 524F1A4B.20606@gmail.com
обсуждение исходный текст
Ответ на Unique index VS unique constraint  (JORGE MALDONADO <jorgemal1960@gmail.com>)
Список pgsql-sql
On 10/04/2013 09:48 AM, JORGE MALDONADO wrote:
> I have search for information about the difference between "unique
> index" and "unique constraint" in PostgreSQL without getting to a
> specific answer, so I kindly ask for an explanation that helps me
> clarify such concept.

The way I think of it is, that since the SQL standard does not mention 
indices an INDEX (UNIQUE or otherwise) is just the databases application 
of a constraint. So for practical purposes they are the same thing.

>
> Respectfully,
> Jorge Maldonado


-- 
Adrian Klaver
adrian.klaver@gmail.com



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

Предыдущее
От: "lucazeo@gmail.com"
Дата:
Сообщение: Re: Unique index VS unique constraint
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Unique index VS unique constraint