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/