Please help regarding partial index

From: Alan Wayne <alanjwayne(at)yahoo(dot)com>
To: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Please help regarding partial index
Date: 2002-05-15 22:30:09
Message-ID: 20020515223009.95572.qmail@web21205.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Arindam Haldar 2002-05-15 22:37:38 C & C ++Program Problem
Previous Message Sean Chittenden 2002-05-15 22:18:52 Should be easy enough to get this result (or is it possible?)...