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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hasan Mokhtari Sangchi <mokhtari(at)hadid(dot)sharif(dot)ac(dot)ir>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: I can not create Index on a feild by type 'timestmp'!
Date: 2001-04-25 16:44:58
Message-ID: 29411.988217098@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hasan Mokhtari Sangchi <mokhtari(at)hadid(dot)sharif(dot)ac(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lieven Van Acker 2001-04-25 16:46:37 Re: Joined table view - multiple delete action rule
Previous Message Nils Zonneveld 2001-04-25 16:44:35 Re: Newbie struggling to set $PGDATA