Index on tinterval ?

From: David Sauer <davids(at)penguin(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Index on tinterval ?
Date: 1999-11-03 05:44:44
Message-ID: m24sf49lir.fsf@chameleon.localdomain
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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(at)penguin(dot)cz (mime compatible)

Browse pgsql-general by date

  From Date Subject
Next Message Stiaan 1999-11-03 08:58:21 Installing Postgresql
Previous Message Chris Teli 1999-11-03 02:00:26 Contrib Array