Re: adddepend and partial indexes

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: SZ?CS Gábor <surrano(at)mailbox(dot)hu>, pgsql-general(at)postgresql(dot)org
Subject: Re: adddepend and partial indexes
Date: 2003-06-17 15:04:51
Message-ID: 20030617150451.GA15503@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2003-06-17 15:06:12 Re: tsearch - v2 new dict
Previous Message Dennis Gearon 2003-06-17 15:03:52 Re: full featured alter table?