Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA05453; Mon, 29 Jun 92 20:59:34 -0700 Message-Id: <9206300359.AA05453@postgres.Berkeley.EDU> From: "Masaki Hirabaru" Subject: Re: Problems with "abstime" data type and multiple rules To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu In-Reply-To: Your message of Mon, 29 Jun 92 17:05:09 MST. <01GLTP7OVXC09TDYEX@otago.ac.nz> Date: Tue, 30 Jun 92 12:56:22 +0900 From: "Masaki Hirabaru" >> Problems with "abstime" data type >> >> c) The data type "abstime" requires entering the time as well !! >> For example I cannot enter "Jun 17 1990". Why ? It troubled me too. So I always put the time, but 2 digits hours, say "Jun 17 12:00:00 1990" couldn't be entered correctly. Anyway, I fixed the problem. I'm not sure my fix is corerct but it works. I can't wait Version 4. *** src/utils/adt/date.c.orig Fri Nov 22 17:36:40 1991 --- src/utils/adt/date.c Mon Jun 8 12:29:23 1992 *************** *** 906,917 **** p++; /* search for hour:minute:sec option */ ! hour=0; min=0; sec=0; for (i=0; i<=1; i++) { c = *p; - hour = -1; if (isdigit(c)) { if (hour < 0) hour = (c - '0'); --- 906,916 ---- p++; /* search for hour:minute:sec option */ ! hour=-1; min=0; sec=0; for (i=0; i<=1; i++) { c = *p; if (isdigit(c)) { if (hour < 0) hour = (c - '0'); -- Masaki Hirabaru