pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Christophe Labouisse <labouiss@cybercable.fr>
To: pgsql-sql@postgreSQL.org
Subject: [SQL] Index on date_trunc
Date: 30 Apr 1999 07:19:33 +0200
Message-ID: <m3n1zqadne.fsf@gabuzo.meunet> (raw)
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/
view thread (5+ messages) latest in thread
Message-ID: <m3n1zqadne.fsf@gabuzo.meunet> Permalink: ../m3n1zqadne.fsf@gabuzo.meunet/ Also on: postgresql.org/message-id/m3n1zqadne.fsf@gabuzo.meunet ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-sql@postgresql.org Cc: labouiss@cybercable.fr Subject: Re: [SQL] Index on date_trunc In-Reply-To: <m3n1zqadne.fsf@gabuzo.meunet> References: <m3n1zqadne.fsf@gabuzo.meunet> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox