Thread

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

Oliver Fischer <plexus@snafu.de> — 1999-11-10T20:22:28Z

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@pobox.com)


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



#--{ plexus@snafu.de }----------------------------
Oliver Fischer, Gleimstrasse 59, 10437 Berlin, Germany