Thread

1. No index support for date/time types?

   Todd Vierling <tv@pobox.com> — 1999-11-07T19:43:10Z

   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)
   
   
   

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

   Todd Vierling <tv@pobox.com> — 1999-11-07T20:05:56Z

   : 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)