Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA14057; Wed, 24 Jul 91 13:10:17 -0700
Message-Id: <9107242010.AA14057@postgres.Berkeley.EDU>
From: mao@postgres.Berkeley.EDU (Mike Olson)
Subject: Re: index on datetime types
To: postgres@postgres.berkeley.edu
In-Reply-To: Your message of "Wed, 24 Jul 91 12:25:30 PST."
             <9107241922.AA04338@dpi.inpe.br> 
Date: Wed, 24 Jul 91 13:09:14 PDT

you can define an index on data of type 'abstime' by using

	define index xyzzy on mytable using btree (myattribute abstime_ops)

there's no distinguished type in postgres called 'datetime', so i assume
that 'abstime' is what you want.
					mike olson
					postgres research group
					uc berkeley
					mao@postgres.berkeley.edu