Indexing Timestamp Data

From: Romualdo Alves <romualdo(at)crn(dot)inpe(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: Indexing Timestamp Data
Date: 1998-05-15 16:07:35
Message-ID: 3.0.5.32.19980515170735.0092e490@jerimum.crn.inpe.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

How to index a timestamp data in a Postgres table?

For example, I tried: CREATE UNIQUE INDEX idx ON table_01 (xtime);
The resulting message was: "CAN'T FIND A DEFAULT OPERATOR CLASS FOR TYPE
1296".

The table 'table_01' was created with the following command:
CREATE TABLE table_01 (
xtime TIMESTAMP,
code CHAR(5),
qty INTEGER);

The key of this table must be the 'xtime' field which is of TIMESTAMP data
type. How to do it?

Romualdo.

------------------------------------------------------------
My ICQ# 10480879
My Home Page: http://wwp.mirabilis.com/10480879
My E-mail Express: 10480879(at)pager(dot)mirabilis(dot)com
INPE Telephone Number: (084) 231-4733 Ext. 214

"For we are labourers together with God" (1 Corinthians 3:9)
"De Deus somos cooperadores" (1 Corintios 3:9)
------------------------------------------------------------

Browse pgsql-sql by date

  From Date Subject
Next Message Andy Lewis 1998-05-15 20:01:20 Duplicate rows
Previous Message Thomas Good 1998-05-15 14:04:46 subscribe