6.5 indexes on timestamp/abstime don't appear to work

From: jim(at)reptiles(dot)org (Jim Mercer)
To: pgsql-bugs(at)postgresql(dot)org
Subject: 6.5 indexes on timestamp/abstime don't appear to work
Date: 1999-06-02 00:18:59
Message-ID: m10oykF-00080vC@mailbox.reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Your name : Jim Mercer
Your email address : jim(at)reptiles(dot)org

System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium

Operating System (example: Linux 2.0.26 ELF) : FreeBSD 2.2.8

PostgreSQL version (example: PostgreSQL-6.5) : PostgreSQL-6.5beta1

Compiler used (example: gcc 2.8.0) : gcc

Please enter a FULL description of your problem:
------------------------------------------------

CREATE TABLE foo
(
mark abstime;
subnet inet;
bytes_in float8;
bytes_out float8;
);

CREATE INDEX foo_by_time ON foo (mark);
CREATE INDEX foo_by_subnet ON foo (subnet);

queries don't use foo_by_time

Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

as above.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Browse pgsql-bugs by date

  From Date Subject
Next Message Filip Zawadiak 1999-06-02 11:58:02
Previous Message Heiko Klein 1999-05-31 12:06:18 Postgres-Solaris Socket Bug