Skip site navigation (1) Skip section navigation (2)

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

From: Oliver Fischer <plexus(at)snafu(dot)de>
To: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] No index support for date/time types?
Date: 1999-11-10 20:22:28
Message-ID: m11lfQF-000HFUC@www.xshare.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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

pgsql-bugs by date

Next:From: Tom LaneDate: 1999-11-11 03:24:15
Subject: Re: [BUGS] Possible bug in postgres || libpq
Previous:From: Chana SlutzkinDate: 1999-11-09 10:19:23
Subject: bug report

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group