Re: adddepend and partial indexes - Mailing list pgsql-general

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