Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 93A3D476D44 for ; Thu, 6 Jun 2002 13:50:26 -0400 (EDT) Received: from davinci.ethosmedia.com (davinci.ethosmedia.com [209.10.40.250]) by postgresql.org (Postfix) with ESMTP id CB2284766F0 for ; Thu, 6 Jun 2002 13:41:19 -0400 (EDT) Received: from [66.219.92.2] (HELO chocolate-mousse) by davinci.ethosmedia.com (CommuniGate Pro SMTP 3.5.9) with ESMTP id 1501559; Thu, 06 Jun 2002 10:41:18 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Stephan Szabo Subject: Re: Indexing timestamps Date: Thu, 6 Jun 2002 10:41:52 -0700 X-Mailer: KMail [version 1.4] Cc: Andre Schubert , References: <20020606095611.A27330-100000@megazone23.bigpanda.com> In-Reply-To: <20020606095611.A27330-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200206061041.52753.josh@agliodbs.com> X-Archive-Number: 200206/59 X-Sequence-Number: 8024 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= =20 problem? What would be the pitfall of creating an alternate version of=20 NOW() that ISCACHABLE? --=20 -Josh Berkus ______AGLIO DATABASE SOLUTIONS___________________________ Josh Berkus Complete information technology josh@agliodbs.com and data management solutions (415) 565-7293 for law firms, small businesses fax 621-2533 and non-profit organizations. San Francisco