Error during creation of indexes

From: Florian Steffen <fsteffen(at)urbanet(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: Error during creation of indexes
Date: 2000-11-15 10:49:37
Message-ID: 20001115114937.N29199@samaris
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I tried to execute the following statements:

CREATE TABLE events (name NAME, description TEXT, date TINTERVAL);
CREATE INDEX events_date_idx ON events (date);

The first statement is executed without any problem, but when I'm running the
second one, I've got the following message:

ERROR: DefineIndex: type tinterval has no default operator class

What does that mean ? I would use an index to speed up queries to find all
events in a specified period of time, e.g. SELECT * FROM events WHERE date &&
('2000-12-20' <#> '2000-12-30');

Can anybody help me ? Thanks in advance,

Florian

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jan Wieck 2000-11-15 11:26:22 Re: 'currency' question; precision/decimal meaing
Previous Message Jan Wieck 2000-11-15 10:20:39 Re: Re: Requests for Development