Please help regarding partial index

Поиск
Список
Период
Сортировка
Искать

Please help regarding partial index

От:
Alan Wayne <alanjwayne@yahoo.com>
Дата:
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
FAQ