Sender: owner-postgres95@postgres.Berkeley.EDU
X-Return-Path: andrew_yu
Received: from internet.milkyway.com (milkyway.com [198.53.167.2]) by nobozo.CS.Berkeley.EDU (8.6.10/8.6.3) with ESMTP id JAA05597 for <postgres95@nobozo.CS.Berkeley.EDU>; Wed, 8 Nov 1995 09:19:00 -0800
Received: from jupiter.milkyway.com (jupiter.milkyway.com [192.168.77.9])
	by internet with ESMTP (DuhMail/2.0)
	id MAA01693; Wed, 8 Nov 1995 12:26:26 -0500
Received: from calisto.milkyway.com (gmckesey@calisto.milkyway.com [192.168.77.2]) by jupiter.milkyway.com (8.6.12/8.6.12) with ESMTP id MAA29074 for <postgres95@nobozo.CS.Berkeley.EDU>; Wed, 8 Nov 1995 12:17:57 -0500
From: Gregory McKesey <gmckesey@milkyway.com>
Received: by calisto.milkyway.com (8.6.7/Sun-Client)
	id MAA18800; Wed, 8 Nov 1995 12:13:54 -0500
Date: Wed, 8 Nov 1995 12:13:54 -0500
Message-Id: <199511081713.MAA18800@calisto.milkyway.com>
To: postgres95@postgres.Berkeley.EDU
Subject: Time Range Queries
Resent-To: postgres95-redist
Resent-Date: Wed, 08 Nov 95 09:19:02 -0800
Resent-From: pglite
Resent-XMts: smtp


I am trying to find a simple way to do a query on time ranges.  I
would like to search for all records between 10:00 and 11:00 on
any date.  I have an abstime field in all records that I want to
search. If I could do a regular expression search on abstime, I
suppose that would work, but I don't believe that this is possible.

Does anyone have any suggestion?  Or is a brute force method the only
way to do this?  Answers using pgtcl or pgperl are welcome.

____________________________________________________________________
Gregory McKesey	
Manager, Application Software		Milkyway Networks Corp.
Tel: (613)596-5549 			2650 Queensview Dr., Suite 255
Fax: (613)596-5615	       		Ottawa, Ontario, Canada.
gmckesey@milkyway.com			K2B-8H6
--------------------------------------------------------------------

===============================================================================
  To unsubscribe from the Postgres95 mailing list, send mail with the subject
  line "DEL" to "postgres95-request@postgres.Berkeley.EDU". 
============  URL: http://s2k-ftp.CS.Berkeley.EDU:8000/postgres95/  ===========
