On 27 Sep 2001, Arcady Genkin wrote:
> 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);
Apart from the index for unique being a unique index, I believe so.
In response to
pgsql-general by date
|Next:||From: frederic massot||Date: 2001-09-28 16:13:36|
|Subject: Re: Problem with the accents|
|Previous:||From: Bruce Momjian||Date: 2001-09-28 15:30:19|
|Subject: Re: Encoding passwords|