Re: Unique Index vs. Unique Constraint

Then what is the difference in these two statements?

alter table Table1
add constraint Table1_UC1
unique (Field1, Field2)

and

create unique index Table1_Field1Field2
on Table1 (Field1, Field2)

Thanks,
Thomas LeBlanc

>From: Dennis Gearon <gearond(at)fireserve(dot)net>
>To: Thomas LeBlanc <thomasatiem(at)hotmail(dot)com>
>Subject: Re: [GENERAL] Unique Index vs. Unique Constraint
>Date: Fri, 10 Oct 2003 15:16:12 -0700
>
>Uniquely so!
>
>Thomas LeBlanc wrote:
>
>>Does a Unique Constraint build a unique index?
>>
>>What is the difference?
>>
>>Thanks,
>>Thomas LeBlanc
>>
>>_________________________________________________________________
>>Get a FREE computer virus scan online from McAfee.
>>http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>

_________________________________________________________________
Help protect your PC. Get a FREE computer virus scan online from McAfee.
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963