Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA20993; Thu, 7 Nov 91 13:19:37 -0800
Message-Id: <9111072119.AA20993@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: abstime
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of "Mon, 28 Oct 91 16:19:14 EST."
             <9110290048.AA26479@postgres.Berkeley.EDU> 
Date: Thu, 07 Nov 91 13:19:14 PST

In message <9110290048.AA26479@postgres.Berkeley.EDU> you write:
> I'm having some problems with the abstime data type under postgres. I've
> created some tuples that have fields of type abstime that were initially
> set to "".  When I do a retieve they show up as epoch but i am unable to
> retrieve them by specifying either epoch or "" as shown here:
> 
> retrieve (repair.all) where repair.date=""
> 
> or
> 
> retrieve (repair.all) where repair.date=""
> 
> Is there some way to retrieve on NULL dates?

I was able to retrieve the tuples you describe by specifying the epoch
date explicitly:

  retrieve (repair.all) where repair.date = "Dec 31 16:00:00 1901 PDT"::abstime

> Also there is an addition problem that postgres does not return dates of type
> abstime in the same form that it accepts them because it appends the time
> zone to the end of the value returned, yet it will not accept a timezone on
> a date value that has been entered.

you are correct.


Jeff Meredith
mer@postgres.berkeley.edu