On Tue, 17 Jun 2003, Bruno Wolff III wrote:
> On Tue, Jun 17, 2003 at 07:48:06 -0700,
> Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)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.