Re: Help Please on partial index - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Help Please on partial index
Date
Msg-id 20020516110114.B16632@svana.org
Whole thread Raw
In response to Help Please on partial index  (Alan Wayne <alanjwayne@yahoo.com>)
List pgsql-general
On Wed, May 15, 2002 at 03:17:49PM -0700, Alan Wayne wrote:
> Hi all!
>
> This is trully embarassing--why is my parser choking
> on this (am I missing a ' or something?):
>
> create unique index idx_zpeople_ichart on zpeople
> (ichart) where ichart > 0;

What version of postgres? Partial indexes wern't available till 7.2.

HTH,

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Force a merge join?
Next
From: Martijn van Oosterhout
Date:
Subject: Re: C & C ++Program Problem