Postgres Pro
Downloads
Home   >   mailing lists

Index on Date_Trunc - Mailing list pgsql-general

From Nathan Barnett
Subject Index on Date_Trunc
Date
Msg-id MHEJIGLIMNDMHOMFOJDEEEGGCCAA.nbarnett@cellularphones.com
Whole thread Raw
Responses Re: Index on Date_Trunc  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Doesn't use index, why?
Next
From: Nelio Alves Pereira Filho
Date:
Subject: pgaccess