Re: I can not create Index on a feild by type 'timestmp'! - Mailing list pgsql-general

From Tom Lane
Subject Re: I can not create Index on a feild by type 'timestmp'!
Date
Msg-id 29411.988217098@sss.pgh.pa.us
Whole thread Raw
In response to I can not create Index on a feild by type 'timestmp'!  (Hasan Mokhtari Sangchi <mokhtari@hadid.sharif.ac.ir>)
List pgsql-general
Hasan Mokhtari Sangchi <mokhtari@hadid.sharif.ac.ir> writes:
> If I want to create an index on a field by type 'timestamp'
> postgres give me following error message :
>     ' can not find a default operator class for type 1296.'
> what can I do ?

Upgrade to a more recent version of Postgres.

Or, change the field to be type datetime, which is the better-supported
datatype in old versions...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Newbie struggling to set $PGDATA
Next
From: Matthew Hixson
Date:
Subject: Re: