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