From: Hijax <hijax_pl@wp.pl>
To: pgsql-sql@postgresql.org
Subject: functional index
Date: Wed, 31 Dec 2003 11:55:38 +0100
Message-ID: <bsu9va$1r8q$1@news.atman.pl> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hijax_pl@wp.pl
Subject: Re: functional index
In-Reply-To: <bsu9va$1r8q$1@news.atman.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox