Re: Indexing timestamps

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?

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                       Josh Berkus  Complete
informationtechnology     josh@agliodbs.com   and data management solutions     (415) 565-7293  for law firms, small
businesses     fax 621-2533   and non-profit organizations.     San Francisco