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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
