Re: Difference between UNIQUE constraint vs index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Brandon Aiken" <BAiken(at)winemantech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Difference between UNIQUE constraint vs index
Date: 2007-02-28 16:03:20
Message-ID: 4211.1172678600@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Brandon Aiken" <BAiken(at)winemantech(dot)com> writes:
> SQLite, MySQL, and MS Access each use indexes for unique constraints.
> Doesn't the SQL spec specify that CREATE INDEX can be used to create
> UNIQUE indexes?

No, there is no such command in the SQL spec. In fact the concept of an
index does not appear anywhere in the spec ... it's an implementation
detail.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Dale 2007-02-28 16:12:06 Re: PostgreSQL 8.2.3, Jboss 4.0.3 and postgresql-8.2-504.jdbc4
Previous Message Andrew Madu 2007-02-28 15:59:09 PostgreSQL 8.2.3, Jboss 4.0.3 and postgresql-8.2-504.jdbc4