Dear Bruno,
I have no prob with "create index". I have prob with "alter table". A
figured that adddepend would do the index via "alter table" to ensure
dependencies.
Dear Stephan,
thanks for your opinion. I think I can ignore adddepend's parse errors on
this; however:
Is there a bug-report or fix-report or CVS place for adddepend? I'd gladly
do a quick-fix for this and the opclass thing (if someone helps with that
one).
G.
------------------------------- cut here -------------------------------
----- Original Message -----
From: "Bruno Wolff III" <bruno@wolff.to>
Sent: Tuesday, June 17, 2003 5:04 PM
> 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