Re: Error trying to create a functional index.

From: CoL <col(at)mportal(dot)hu>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Error trying to create a functional index.
Date: 2002-01-08 11:57:27
Message-ID: 3C3ADEA7.9090303@mportal.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

Jochem van Dieten wrote:

> CoL wrote:
>
>> Steve: of course you can make functional indices:
>>
>> So why this not workin???? (not workin for me 2 too, pg 7.1.3)
>> "CREATE INDEX eventdateindex ON event (date_trunc('day', eventstamp));"
>>
>
> Wouldn't your problem be that 'day' is a constant?
> Jochem

sure it is, but date_trunc takes this, so what is the way to create a date_trunc part or any

date function index on a timestamp?

Or it's not possible?

CoL

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jochem van Dieten 2002-01-08 12:10:21 Re: Error trying to create a functional index.
Previous Message Jochem van Dieten 2002-01-08 11:27:28 Re: Error trying to create a functional index.