Error during creation of indexes

Поиск
Список
Период
Сортировка
От Florian Steffen
Тема Error during creation of indexes
Дата
Msg-id 20001115114937.N29199@samaris
обсуждение исходный текст
Ответы Re: Error during creation of indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Ivan Janssen"
Дата:
Сообщение: Use of variables within a select statement in a function
Следующее
От: Joe Kislo
Дата:
Сообщение: Transaction, Rollback and Database Corruption question,