Florian Steffen <fsteffen(at)urbanet(dot)ch> 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