Postgres Pro
Downloads
Home   >   mailing lists

functional index - Mailing list pgsql-sql

From Hijax
Subject functional index
Date
Msg-id bsu9va$1r8q$1@news.atman.pl
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: John Coryat
Date:
Subject: Complex Update
Next
From: Tatsuo Ishii
Date:
Subject: Re: DO INSTEAD in rule