From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Josh Berkus <josh(at)agliodbs(dot)com> |
Cc: | Andre Schubert <andre(dot)schubert(at)km3(dot)de>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Indexing timestamps |
Date: | 2002-06-06 22:33:30 |
Message-ID: | 20020606152814.P30776-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Thu, 6 Jun 2002, Josh Berkus wrote:
>
> Stephan,
>
> > Unfortunately you can't do that in that sort of syntax. You'll
> > need to create a function that returns the month and is marked
> > as iscachable and use that function in the index creation and
> > query.
>
> Hmmm. I take it that NOW() is not ISCACHABLE, and that's Andre's indexing
> problem? What would be the pitfall of creating an alternate version of
> NOW() that ISCACHABLE?
I believe it was not marked as iscachable. I think it's now marked as
static in dev sources which I would guess would mean that it could
consider an index scan. I think with care an iscachable function that
just called now() would probably be safe for interactive queries.
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Syjuco | 2002-06-07 00:03:49 | how to reset serials |
Previous Message | Manfred Koizar | 2002-06-06 20:52:52 | Re: Old documentation |