[SQL] Index on date_trunc

X-From-Line: owner-pgsql-sql@hub.org  Fri Apr 23 06:48:33 1999
Return-Path: <owner-pgsql-sql@hub.org>
Delivered-To: labouiss@cybercable.fr
Received: from mail.cybercable.fr
    by localhost with POP3 (fetchmail-5.0.1)
    for moi@localhost (single-drop); Fri, 23 Apr 1999 06:48:33 +0200 (CEST)
Received: (qmail 4517 invoked from network); 22 Apr 1999 22:31:12 +0200
Received: from hub.org (209.47.145.100)
  by bouvreuil.cybercable.fr with SMTP; 22 Apr 1999 20:31:12 -0000
Received: from localhost (majordom@localhost)
    by hub.org (8.9.3/8.9.1) with SMTP id QAA12080;
    Thu, 22 Apr 1999 16:30:50 -0400 (EDT)
    (envelope-from owner-pgsql-sql@hub.org)
Received: by hub.org (TLB v0.10a (1.23 tibbs 1997/01/09 00:29:32)); Thu, 22 Apr 1999 16:29:27 +0000 (EDT)
Received: (from majordom@localhost)
    by hub.org (8.9.3/8.9.1) id QAA11449
    for pgsql-sql-outgoing; Thu, 22 Apr 1999 16:29:25 -0400 (EDT)
    (envelope-from owner-pgsql-sql@postgreSQL.org)
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 <pgsql-sql@postgreSQL.org>; 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
Mime-Version: 1.0 (generated by tm-edit 7.108)
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <m3r9pcbe3m.fsf@gabuzo.meunet>
X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald"
Sender: owner-pgsql-sql@postgreSQL.org
Precedence: bulk
X-Sorted: ML-PSQL-SQL
Lines: 18
Xref: gabuzo.meunet ML-PSQL-SQL:676

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/