No index support for date/time types?
Todd Vierling <tv@pobox.com>
From: Todd Vierling <tv@pobox.com>
To: pgsql-bugs@postgresql.org
Date: 1999-11-07T19:43:10Z
Lists: pgsql-bugs
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)