Re: adddepend and partial indexes

On Tue, 17 Jun 2003, Bruno Wolff III wrote:

> On Tue, Jun 17, 2003 at 07:48:06 -0700,
>   Stephan Szabo <sszabo@megazone23.bigpanda.com> wrote:
> >
> > AFAIK there's no such thing as a partial unique constraint so the index
> > should probably just be left alone.
>
> bruno=> create table test (col int);
> CREATE TABLE
> bruno=> create unique index test1 on test(col) where col < 100;
> CREATE INDEX

That's a partial unique index, not a partial unique constraint. ;)
Which I believe is the point, there's no ALTER TABLE ADD CONSTRAINT that
presumably makes such an index.