Index on tinterval ? - Mailing list pgsql-general

From David Sauer
Subject Index on tinterval ?
Date
Msg-id m24sf49lir.fsf@chameleon.localdomain
Whole thread Raw
List pgsql-general
Hello,

  when I want make index on tinterval type, I get this message:

david=> create table t(i tinterval);
CREATE
david=> create index t_i_index on t(i);
ERROR:  Can't find a default operator class for type 704.

I hope, that I can make index - operators such '<','>','=' etc. are
defined.
Does anybody knows, what I need to do ?


                                                thanks,

                                                        David

--
* David Sauer, student of Czech Technical University
* electronic mail: davids@penguin.cz (mime compatible)

pgsql-general by date:

Previous
From: "Chris Teli"
Date:
Subject: Contrib Array
Next
From: "Natalya S. Makushina"
Date:
Subject: Problem: pq_recvbuf: unexpected EOF of client connection