functional index

From: "Hijax" <hijax_pl(at)wp(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: functional index
Date: 2003-12-31 10:55:38
Message-ID: bsu9va$1r8q$1@news.atman.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2003-12-31 15:23:45 Re: postgreSQL editors
Previous Message Michael Glaesemann 2003-12-31 05:02:20 Re: postgreSQL editors