Received: from earth.hub.org (earth.hub.org [64.49.215.11]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAMEfnm38809 for ; Thu, 22 Nov 2001 09:41:49 -0500 (EST) (envelope-from scrappy@hub.org) Received: from localhost (scrappy@localhost) by earth.hub.org (8.11.3/8.11.4) with ESMTP id fAMEfrw35416 for ; Thu, 22 Nov 2001 09:41:53 -0500 (EST) (envelope-from scrappy@hub.org) Date: Thu, 22 Nov 2001 09:41:53 -0500 (EST) From: "Marc G. Fournier" To: pgsql-sql@postgresql.org Subject: INDEXng date_trunc ... Message-ID: <20011122094048.T64011-100000@earth.hub.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200111/317 X-Sequence-Number: 5699 In v7.2, how does one index a function? CREATE INDEX hourly_stats_day ON hourly_stats USING btree ( DATE_TRUNC('day',runtime) ) ; Gives me: ERROR: parser: parse error at or near "'" so I'm obviously doing it wrong :) Thanks ...