I can not create Index on a feild by type 'timestmp'!

That sounds like an old error to me if I recall correctly. What
version of PostgreSQL are you using?

SELECT version();

Mike Mascari
mascarm@mascari.com

-----Original Message-----
From: Hasan Mokhtari Sangchi [SMTP:mokhtari@hadid.sharif.ac.ir]
Sent: Wednesday, April 25, 2001 5:55 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] I can not create Index on a feild by type
'timestmp'!

Hellor dear.
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 ?

Thank a lot.

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