Received: from gabuzo.meunet (IDENT:root@d224.paris-204.cybercable.fr [212.198.204.224]) by hub.org (8.9.3/8.9.1) with ESMTP id QAA11262 for ; Thu, 22 Apr 1999 16:27:09 -0400 (EDT) (envelope-from christophe.labouisse@dial.oleane.com) Received: (from moi@localhost) by gabuzo.meunet (8.9.1a/8.9.1/Christophe Labouisse - 10/01/99) id WAA06056; Thu, 22 Apr 1999 22:21:50 +0200 To: pgsql-sql@postgreSQL.org Subject: Index on date_trunc Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit From: Christophe Labouisse Date: 22 Apr 1999 22:21:49 +0200 Message-ID: Lines: 16 X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald" I'm trying to index on a part of a datetime field. I tried the following statement : create index ns_dt1_idx on netstats (date_trunc('day',NS_DATE) datetime_ops); It doesn't work and I get : ERROR: parser: parse error at or near "'" Any idea ? -- Christophe Labouisse : Cinéma, typographie, Unix christophe.labouisse@dial.oleane.com http://www.multimania.com/gabuzo/ Le cinéma en Lumière : http://www.lumiere.org/