Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 28 Feb 2007 11:03:20 -0500
"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
- Follow-Ups:
- Re: Difference between UNIQUE constraint vs index
- From: Brandon Aiken
- Re: Difference between UNIQUE constraint vs index
- References:
- Difference between UNIQUE constraint vs index
- From: John Jawed
- Re: Difference between UNIQUE constraint vs index
- From: Jim C. Nasby
- Re: Difference between UNIQUE constraint vs index
- From: Tom Lane
- Re: Difference between UNIQUE constraint vs index
- From: Brandon Aiken
- Difference between UNIQUE constraint vs index
- Prev by Date: PostgreSQL 8.2.3, Jboss 4.0.3 and postgresql-8.2-504.jdbc4
- Next by Date: Re: Post-Reboot Issue: Postmaster Not Accessible
- Previous by thread: Re: Difference between UNIQUE constraint vs index
- Next by thread: Re: Difference between UNIQUE constraint vs index
- Indexes: