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 BAA86587 for ; Fri, 30 Apr 1999 01:24:59 -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 HAA03837; Fri, 30 Apr 1999 07:19:33 +0200 To: pgsql-sql@postgreSQL.org Subject: [SQL] Index on date_trunc Mime-Version: 1.0 (generated by tm-edit 7.108) Content-Type: multipart/mixed; boundary="Multipart_Fri_Apr_30_07:19:33_1999-1" Content-Transfer-Encoding: 7bit From: Christophe Labouisse Date: 30 Apr 1999 07:19:33 +0200 Message-ID: Lines: 64 X-Mailer: Gnus v5.5/XEmacs 20.4 - "Emerald" --Multipart_Fri_Apr_30_07:19:33_1999-1 Content-Type: text/plain; charset=US-ASCII X-From-Line: owner-pgsql-sql@hub.org Fri Apr 23 06:48:33 1999 Return-Path: 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 ; 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: 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 --Multipart_Fri_Apr_30_07:19:33_1999-1 Content-Type: text/plain; charset=US-ASCII 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 ? --Multipart_Fri_Apr_30_07:19:33_1999-1 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit 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/ --Multipart_Fri_Apr_30_07:19:33_1999-1--