Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id MAA02274 for postgres-dist; Tue, 16 Nov 1993 12:09:45 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199311162009.MAA02274@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from cs.uml.edu (cs.uml.edu [129.63.1.11]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id MAA02265 for <postgres@nobozo.CS.Berkeley.EDU>; Tue, 16 Nov 1993 12:09:39 -0800
Received: by cs.uml.edu id AA00563
  (5.67a+/IDA-1.5 for postgres@nobozo.CS.Berkeley.EDU); Tue, 16 Nov 1993 15:09:36 -0500
From: John Peter Lee <jlee@cs.uml.edu>
Message-Id: <199311162009.AA00563@cs.uml.edu>
Subject: time types and indexes
To: postgres@postgres.Berkeley.EDU
Date: Tue, 16 Nov 1993 15:09:34 -0500 (EST)
X-Mailer: ELM [version 2.4 PL22]
Content-Type: text
Content-Length: 1551      
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Tue, 16 Nov 93 12:09:45 -0800
Resent-XMts: smtp

Hi:

  Some more questions on time types:

  Can the time types have indexes made on them ? I guess I'd like to
  know what the internal storage is like - I've had a look through the
  source, but can't seem to find where this info might be :-(
  My data has this temporal element which will be a very important
  key index, among a few others, and I'd like to be sure that Postgres can
  construct an index on the string abstime that is stored in the DB. 
  Does it build on the string, or does Postgres end up storing the date as
  integer data ???

  Also, I'm wondering of whether to use the time types at all, because if
  I change to another DBMS, the interface to time probably will have to
  change. I know I'd have to reload the data into their format, but I'd
  like the application that retrieves the time typed data to not have to
  be changed. Am I safe in assuming that the time type interface is NOT any
  kind of standard ?

  Lastly, is there a limit to the number of indexes that can be constructed
  for a data set ? Each record has ~50 attributes, and I would like to
  build indexes for about 7 of them. I've got about 55,000 records total.


  thanks in advance...

  jp

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
JP Lee               Institute for Visualization and Perception Research	
jlee@cs.uml.edu                    University of Massachusetts at Lowell 
(508) 934-3384			      1 University Ave. Lowell, MA 01854

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~