Re: Unique index VS unique constraint - Mailing list pgsql-sql

From Adrian Klaver
Subject Re: Unique index VS unique constraint
Date
Msg-id 524F1A4B.20606@gmail.com
Whole thread Raw
In response to Unique index VS unique constraint  (JORGE MALDONADO <jorgemal1960@gmail.com>)
List 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 by date:

Previous
From: "lucazeo@gmail.com"
Date:
Subject: Re: Unique index VS unique constraint
Next
From: Adrian Klaver
Date:
Subject: Re: Unique index VS unique constraint