Re: [BUGS] No index support for date/time types?

Hi,

i have the same problem! Is it possible that postgres don´t
support
this feature?

Bye,
Oliver

> I'm getting some strange errors when trying to use a btree
(default)
> index
> on any of timestamp, abstime, datetime, or reltime types. All
fail
> with an
> error:

> (timestamp) ERROR: Can't find a default operator class for
type
> 1296.
> (abstime) ERROR: Cannot create index: attribute 11 does not
exist
> (reltime) ERROR: Can't find a default operator class for type
703.
> (datetime) ERROR: Cannot create index: attribute 12 does not
exist

> ...errors which, of course, mean nothing to me. 8-)

> A simple case to reproduce the first ...

> create table foo (bar timestamp);
> create index baz on foo (bar);

> --
> -- Todd Vierling (tv(at)pobox(dot)com)

> ************

#--{ plexus(at)snafu(dot)de }----------------------------
Oliver Fischer, Gleimstrasse 59, 10437 Berlin, Germany