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/
Show quoted text
Canada, Mexico, and Australia form the Axis of Nations That
Are Actually Quite Nice But Secretly Have Nasty Thoughts About America