No index support for date/time types?

: I'm getting some strange errors when trying to use a btree (default) index

...on 6.5.2, NetBSD/i386.

--
-- Todd Vierling (tv@pobox.com)

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