Help Please on partial index

From: Alan Wayne <alanjwayne(at)yahoo(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Cc: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
Subject: Help Please on partial index
Date: 2002-05-15 22:17:49
Message-ID: 20020515221749.5034.qmail@web21206.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 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sean Chittenden 2002-05-15 22:18:52 Should be easy enough to get this result (or is it possible?)...
Previous Message Johnson, Shaunn 2002-05-15 20:02:02 books on pl/pgsql