pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marc G. Fournier <scrappy@hub.org>
To: pgsql-sql@postgresql.org
Subject: INDEXng date_trunc ...
Date: Thu, 22 Nov 2001 09:41:53 -0500 (EST)
Message-ID: <20011122094048.T64011-100000@earth.hub.org> (raw)


In v7.2, how does one index a function?

CREATE INDEX hourly_stats_day
          ON hourly_stats
       USING btree ( DATE_TRUNC('day',runtime) ) ;

Gives me:

ERROR:  parser: parse error at or near "'"


so I'm obviously doing it wrong :)

Thanks ...




view thread (3+ messages)  latest in thread

Message-ID: <20011122094048.T64011-100000@earth.hub.org>
Permalink:  ../20011122094048.T64011-100000@earth.hub.org/
Also on:    postgresql.org/message-id/20011122094048.T64011-100000@earth.hub.org

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: scrappy@hub.org
  Subject: Re: INDEXng date_trunc ...
  In-Reply-To: <20011122094048.T64011-100000@earth.hub.org>

* 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