Received: from poptop.llnl.gov (poptop.llnl.gov [128.115.18.65]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA34781; Wed, 7 Jul 1999 14:08:26 -0400 (EDT) (envelope-from sbradley@llnl.gov) Received: from oglala (oglala.llnl.gov [128.115.223.27]) by poptop.llnl.gov (8.8.8/LLNL-3.0.2/pop.llnl.gov-5.1) with SMTP id LAA25615; Wed, 7 Jul 1999 11:08:21 -0700 (PDT) Message-Id: <3.0.5.32.19990707111100.00927cf0@poptop.llnl.gov> X-Sender: e097106@poptop.llnl.gov X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.5 (32) Date: Wed, 07 Jul 1999 11:11:00 -0700 To: pgsql-sql@postgresql.org, pgsql-interfaces@postgresql.org From: Steven Bradley Subject: Index on TIMESTAMP Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Is there really no way to create an index on a TIMESTAMP column???? When I try to create the index, I get the following message: ERROR: Can't find a default operator class for type 1296. I noticed that this problem was already posted quite some time ago, and the only response was to use DATETIME instead. Unfortunately, we can't use DATETIME since there is no JDBC method to accessing a DATETIME column. It was previously suggested that the ResultSet.getTimestamp() method would retrieve DATETIME fields, but it doesn't. Perhaps the ResultSet.getTimestamp() method is even more broken than previously thought? Any suggestions? Steven Bradley Lawrence Livermore National Laboratory PO Box 808 Livermore, California 94550 (925) 423-2101 sbradley@llnl.gov