Re: UNIQUE constraint and indexing

On Thu, Sep 27, 2001 at 06:30:50PM -0400, some SMTP stream spewed forth: 
> Is the index, created implicitely by "UNIQUE" constraint, the same
> kind as created explicitely with "CREATE INDEX"?  In other words,
> is the following piece of SQL redundant?
> 
> create table foo (
>        bar serial primary key,
>        baz text not null unique );
> create index foo_baz_idx on foo(baz);

Yes, to the best of my knowledge. 

Daniel M. Kurry

> Many thanks,
> -- 
> Arcady Genkin
> i=1; while 1, hilb(i); i=i+1; end