Index on Date_Trunc

From: "Nathan Barnett" <nbarnett(at)cellularphones(dot)com>
To: "PostgreSQL List" <pgsql-general(at)postgresql(dot)org>
Subject: Index on Date_Trunc
Date: 2001-01-04 17:26:36
Message-ID: MHEJIGLIMNDMHOMFOJDEEEGGCCAA.nbarnett@cellularphones.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to create an index on the date_trunc('day', columna) in a table.
When I try to create this index, I get a parse error near the single quote.
Is there a workaround to create this index? I am using v7.0.3 on FreeBSD.

-Nathan Barnett

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-01-04 17:35:20 Re: problem with mkMakefile.tcldefs.sh if USE_TCL=false
Previous Message Tom Lane 2001-01-04 17:12:18 Re: Doesn't use index, why?