Please help regarding partial index - Mailing list pgsql-general

From Alan Wayne
Subject Please help regarding partial index
Date
Msg-id 20020515223009.95572.qmail@web21205.mail.yahoo.com
Whole thread Raw
List pgsql-general
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 around "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

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: XML from postgreSQL tables
Next
From: Sean Chittenden
Date:
Subject: Should be easy enough to get this result (or is it possible?)...