Обсуждение: functional index

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

functional index

От
"Hijax"
Дата:
HAPPY NEW YEAR EVERYONE !!!!!

Hi all..

Is there any method of creating functinal index using date() function? I
can't create such an index because of uncacheable function...

I have to select gathered data from specific day of year... So I should
create an index for better performance. How can I achive that?

Regards,
Arek

P.S.
I am using PostgreSQL 7.4.0