Thread: Help Please on partial index

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;

It says it can't parse in or arround "where".

zpeople is:

create zpeople (....ichart int2....) .
Zpeople was created successfully.

Thanks,
ajw

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

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