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 MAA02407 for postgres-dist; Tue, 16 Nov 1993 12:23:41 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199311162023.MAA02407@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 heel.CS.Berkeley.EDU (heel.CS.Berkeley.EDU [128.32.149.116]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id MAA02398 for <postgres@nobozo.CS.Berkeley.EDU>; Tue, 16 Nov 1993 12:23:41 -0800
Received: from localhost (avi@localhost) by heel.CS.Berkeley.EDU (8.6.4/8.1B) id MAA03893; Tue, 16 Nov 1993 12:23:37 -0800
Message-Id: <199311162023.MAA03893@heel.CS.Berkeley.EDU>
To: John Peter Lee <jlee@cs.uml.edu>
cc: postgres@postgres.Berkeley.EDU
Subject: Re: time types and indexes 
In-reply-to: Your message of "Tue, 16 Nov 1993 15:09:34 EST."
             <199311162009.AA00563@cs.uml.edu> 
Date: Tue, 16 Nov 1993 12:23:37 -0800
From: avi pfeffer <avi@postgres.Berkeley.EDU>
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Tue, 16 Nov 93 12:23:41 -0800
Resent-XMts: smtp

>   Can the time types have indexes made on them ?

Yes.

>   Does it build on the string, or does Postgres end up storing the date as
>   integer data ???

Integer data.

>   Am I safe in assuming that the time type interface is NOT any
>   kind of standard ?

Yes.

>   Lastly, is there a limit to the number of indexes that can be constructed
>   for a data set ? 

Not as far as I know.