Re: [GENERAL] Error during creation of indexes

[Tom Lane]

Florian Steffen <[EMAIL PROTECTED]> writes:
> CREATE TABLE events (name NAME, description TEXT, date TINTERVAL);
> CREATE INDEX events_date_idx ON events (date);
> ERROR:  DefineIndex: type tinterval has no default operator class

> What does that mean ?

It means there's no support for indexes on tinterval.

tinterval is an obsolete, deprecated datatype; try interval instead.

                        regards, tom lane