Help Please on partial index - Mailing list pgsql-general

From Alan Wayne
Subject Help Please on partial index
Date
Msg-id 20020515221749.5034.qmail@web21206.mail.yahoo.com
Whole thread Raw
Responses Re: Help Please on partial index
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 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

pgsql-general by date:

Previous
From: "Johnson, Shaunn"
Date:
Subject: books on pl/pgsql
Next
From: Doug Fields
Date:
Subject: Force a merge join?